NEW LINE (u2018nlu2019) character problem, because coming in field also

[Former Member]

Hi All,

In file to RFC scenario.

I have NEW LINE (u2018nlu2019) character coming up at the end of row and some time in middle of data also.

How can I distingue between both, pls guide?

Data in file is like below:

A¹²³456

B¹²³456

C^1

23^456

D¹²³456

But Sender File content conversion treating it like:

A 123 456

B 123 456

C 1

23 456

D 123 456

But I want to treat it like, Pls guide some solution, or pls guide if some end of line character I can introduce:

A 123 456

B 123 456

C 123 456

D 123 456

Regards

[Former Member]

You can try using the Fixed recordset length for the "File Content Conversion" protocol (check "NameA.fieldFixedLengths" on the help page below), and then use the Mapping program to remove all extra "\n" characters in the string.

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

[Former Member]

Thanks for reply, but i can not use fieldFixedLengths.

because in my file any number of characters can come in one column zero to1000 character also

and my real file I have 150 column file.

Above I just give dummy easy example to explain question.

[Former Member]

And is it possible to add other characters, like a pipe "|" or a comma "," to separate the fields?

[Former Member]

yes

In my file fieldSeparator is ^.

I can use any thing as row endSeparator which may not part of data

or I can use change fieldSeparator ^ with any other character as fieldSeparator like you are suggesting |.

[baskar_gopalakrishnan2]

>>I can use any thing as row endSeparator which may not part of data

If you use field separator and end separator different character then you dont find any issue. Just follow SAP help link for configuring the file comm channel

Something like

A.FieldSeparator ':'

A.endSeparator 'nl'

[Former Member]

Hi Baskar,

I can not use 'nl' as end seperator because, one of my column data also has new line.

I am trying to use any other character as end seperator other then 'nl' but still column data which has new line is coming as next row.

Please see my above example, what i am saying.

Regards

[Former Member]

Hi All,

I tested endSeperator other characters other then 'nl' or '0x0A'(hex value of new line character), but no other character is working for me as endSeperator.

I am on PI7.1 SP-8.

I think I have to EDIT file using ABAP code to remove new line characters from data-column-fields.

Then upload file, using file-sender-adapter-content-conversion.

If any PI-expert can suggest any other solution please suggest?

Regards

[Former Member]

solved with ABAP program in interface.