Skip to Content
author's profile photo Former Member
Former Member

Field Containg embedded line breaks

Hi Experts,

I am doing FCC in sender File adapter. My field separator is "I" and Record separator is "\n".

In my .txt input file, one of field contains embedded line breaks and Adapter is taking that break as end of that record.

Without changing the file format & without using custom adapter module, how this problem can be resolved?

Thanks

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 02, 2011 at 09:12 AM

    Hi,

    in "endSeparator" do not use '\n', but it's hexadecimal value '0x0A' (including simple quote).

    If that does not works try with '0x0D''0x0A'. eventually try with 'nl'.

    by this way the '\n' of end of line should be interpreted as a end of line (of course), and your '\n' in the field should be ⚠️ interpreted a string character. should be...

    CR (0x0D) = CarriageReturn

    LF (0x0A) = LineFeed

    if previous solution does works, try with options "enclosureSign".

    [http://help.sap.com/saphelp_nwpi711/helpdata/en/44/6713ec3f914ddee10000000a1553f7/content.htm]

    mickael

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 02, 2011 at 06:18 AM

    Try to use XSLT mapping to remove the special characters.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.