Skip to Content
avatar image
Former Member

file adapter - fieldSeparator parameter

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 08, 2007 at 06:09 AM

    Hi

    In FCC

    Write DT_Header.fieldSeparator='0x20'

    The hexadecimal notation for the space is 0x20.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 08, 2007 at 06:13 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 08, 2007 at 06:16 AM

    You can go throught the blog

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

    <b>Cheers,

    *RAJ*</b>

    Add comment
    10|10000 characters needed characters exceeded