Content Conversion of broken pipe delimiter in File Adapter

[Former Member]

Having trouble parsing a flat file that is broken pipe delimited. Trying to use the (name.fieldSeparator) and a hexadecimal representation of '0x6A' with no success. We can parse the file w/o issues when it is pipe delimited (|).

Has anyone experienced a similar issue/scenario?

Thanks.

Duke

[Former Member · Accepted solution]

Hi Duke,

Try the field seperator as "c2a6", this code refer to broken pipe in Unicode.

can refer the link: http://www.utf8-chartable.de/

regards,

Chandra Shekhar.

[Former Member · Accepted solution]

Hi Chandra,

Unfortunately that did not work as well. When we open the payload and use the character that the separator is interpreted as, it works. Looking into a different solution.

Thanks for all the help.

[Former Member]

Duke,

Can you try with '0x7c'.

If this doesnot work put all caps like 0X7C and see.

Regards,

---Satish

[Former Member]

Hi Satish,

Unfortunately that did not work.

Thanks.

Duke

[Former Member]

Duke,

I gave that representation from this link:

http://web.cs.mun.ca/~michael/c/ascii-table.html

Are you getting any error on sender communication channel?

---Satish

[Former Member]

Hi Satish,

No errors, when looking at the payload the broken pipe is represented as º582146439º, and thus is not separated correctly. I tried using different encodings and the same result except for the character looking differently in the payload.

Thanks,

Doo