Variable Substitution for File Name Scheme

[Former Member]

Hi all,

Please clarify the following issue.

I have two source fields

Transfer Order number - 0000000222

Transfer Order line item - 0001

Both i map it into one target field

The target field output is - 0000000222#0001

I need a file name which starts with ABC <TranferOrderNumber>.txt

The problem is, when i try to use payload i get output

(ABC0000000222#0001.txt). The reason is i use the target field which was concatenated. I don't have any target field with only transfer order no.

Please give me a solution where i would get output

(ABC0000000222.txt).

Thanks in advance,

Jose Augastine

[moorthy]

Hi,

Other way may be like this ..Create a one more segment in your target structure with field name as Transfer Order No. And populate only this no. And in the Reciever File adapter , in the variable sub, use only this field. But this new segment will come in the file. To avoid this, you can make use of " Cut " Parameter in the File Content Conversion.

This will hold good, if you have content conversion-

/people/sravya.talanki2/blog/2005/08/11/solution-to-the-problem-encountered-using-variable-substitution-with-xi-sp12

Otherwise, you can think of Bhavesh's suggestion

Regards,

Moorthy

[bhavesh_kantilal]

Hi,

The same thread has been answered here,

Regards,

Bhavesh