Problem with Varibale substitution

[former_member188791]

Hi Group,

In one of the requirements I am generating file name in mapping by using extra node in target structure,in ID using variable substitution I am passing node to generate file name,but extra blank line is creating at the end of file,when I search on SCN I found couple of post on this issue but not finding any relevant answer,here i am attaching node and ID config parameters,please can any body suggest.

ESR Target Node:

------------------------

File

  Name

ID Parameters

------------------------------

File.fieldFixedLengths                          0

File.fixedLengthTooShorHandling          Cut

File.endSeparator                               0

Variable Substitution

------------------------------

var          payload:MT_app11,1,File,1,Name,1

File Name Scheme

------------------------------

%var%.csv

[iaki_vila]

Hi Rajiv,

One of the parameters have a mistake in the name:

fixedLengthTooShortHandling      Cut

Try it putting the 't'

Regards.

[Former Member]

that was a great observation.. Appreciated.......!!!!!!!!!!!!!!!1

[former_member188791]

Hi Inaki,

Its actually typo mistake,but in original ID configuration "t" is there ,still its not working

[zameerf]

May be you can give the screenshot of complete FCC config.

Just wanted to check your complete FCC parameters

[Former Member]

HI Rajiv,

Can you provide the target expected format or sample data.

The configuration that you provided,

File.fieldFixedLengths                          0    -  field length is '0' provide the appropriate value

File.fixedLengthTooShorHandling          Cut   - Correct

File.endSeparator                               0   - is your end Separator is '0'

Keep the file content conversion in the below order and check:

File.fieldFixedLengths

File.endSeparator 

File.fixedLengthTooShorHandling

This should work.

Thanks,

[former_member188791]

Hello Hanumantha,

I tried your option still its not wrking

[Former Member]

Can you please provide the target sample file data.

So, that I would be able to provide some solution for your question..

[gagandeep_batra]

Hi Rajiv,

did you try with  property in  File adapter "lastFieldOptional" is "TRUE"

and make file name as last field

Regards

Gagan

[zameerf]

Hi Rajiv,

Can you try with,

File.endSeparator '0'

Regards,

Zameer

[former_member188791]

Hi Zameer,

Yes,I tried with '0' ,its not working.