MessageTransformBean tab as fieldSeparator

[errol_sayre]

I have a working PI process which builds a CSV based file for upload to a third party SFTP site, however they vendor has requested that I provide a tab-delimited file (tsv) rather than comma delimited (csv).

I am unable to determine how to specify a tab character as the fieldSeparator. I have tried a literal tab, a literal tab within single quotes, \t, '\t', 't', 'tab', 'tb', and am unable to find a working mechanism.

The closest I've come has been to include a literal tab within single quotes but the system includes the single quotes. If I omit the quotes, the Integration Directory UI appears to truncate the contents of the cell and the communication channel complains of a missing fieldSeparator.

Anyone have any ideas how to accomplish this?

[javier_alcubilla · Accepted solution]

Hi Errol

Check this thread

PI 7.1 Sender File Adapter - FCC   fi... | SCN

Regards

Javi

[errol_sayre · Accepted solution]

Thank you much. I had tried several variations but hadn't gotten to '0x09'. Curiously I had tried pasting a literal character in but it did't get converted as mentioned in the blog

[former_member226514]

Hi Errol,

Have you tried hex - 0x09?

Please refer the screenshot in the blog

http://scn.sap.com/people/gabrielsagayaselvam.panneerselvam/blog/2009/12/07/standard-adapter-framewo...

http://scn.sap.com/people/gabrielsagayaselvam.panneerselvam/blog/2009/08/31/solve-key-field-problem-...

Regards,

Karthik