File Content Conversion on the Receiving side

[Former Member]

Is there a way in which if I want a Pipe Delimited File as a result, after the last field also I get a pipe with next record starting in the next line.

[Former Member]

hi,

in the mapping u just use CONACT function with constant having ||,

(OR)

u can use elment.fieldSeparator:||

Thanks,

Madhav

[Former Member]

Hi,

For | (Pipe), use corresponding hex code as fieldSeparator i.e. 0x7C as fieldSeparator.

For FCC on receiver side refer -

[Simple FCC|http://www.riyaz.net/blog/index.php/2008/02/19/xipi-file-content-conversion-for-simple-structure/], [Complex FCC|http://www.riyaz.net/blog/index.php/2008/02/20/xipi-file-content-conversion-for-complex-structures/]

For separotor at the end of line you can try using a dummy field or use combination of pipe and newline i.e. '0x7C' and '0x0D' (stands for carriage return) or 'nl' as endSeparator

Edit: You might consider using 'nl' as beginSeparator parameter and 0x7C as endSeparator. This will do the trick. However, this would add a blank line in the beginning of the file.

Hope this helps.

Regards,

Riyaz

Edited by: Riyaz Sayyad on Aug 21, 2008 3:00 PM

[former_member192295]

HI,

Write below statement at receiver adatper

rec.fieldSeparator '|'

rec.endSeparator '|'

i hope it will work

[Former Member]

Use the End seperator as 'nl'.

Field seperator as '|'.

use Last Field as Dummy(NULL) Value

[Former Member]

Hi,

Use the End seperator as well as Field seperator with Pipe so it will add the pipe after every field and after last field of record.

Thanks

Swarup

[Former Member]

Take a dummy field at the end of every record and pass null value. And do Normally what you are doing now.