file adapter - fieldSeparator parameter

[Former Member]

Hello everyone!

I've configured an FTP sender adapter that picks up CSV files. The fields in the file are separated by a spaces, eg. <b>DTL 1 14800575110370 12 0000003</b>

What do I indicate in the "fieldSeparator" parameter of the Content Conversion to indicate that the fields are separated by a 'space'?

Warm regards,

Glenn

[Former Member · Accepted solution]

Hi

In FCC

Write DT_Header.fieldSeparator='0x20'

The hexadecimal notation for the space is 0x20.

Thanks

[Former Member]

You can go throught the blog

/people/shabarish.vijayakumar/blog/2005/08/17/nab-the-tab-file-adapter

<b>Cheers,

*RAJ*</b>

[Former Member]

Thanks for your replies, guys!

I decided to use the 'fieldFixedLengths' parameter instead since I was getting problems using the 'fieldSeparator'

Regards,

Glenn

[Former Member]

Hi

Please mark the question as answered.

Thanks

[Former Member]

Hi,

The Hexadesimal notation for space is '0X20' and fro TAB separator is '0X09'.

for more details check this link.

http://help.sap.com/saphelp_nw70/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/content.htm

Regards,

Phani

Reward points if helpful