Sender File Adapter - Problem with field separator

[Former Member]

Hi,

I want to upload a CSV file into XI.

The file contains a text part which uses from time to time quotation marks like this:

SD,575757,383838,N/A,XYZ,"This is a text part",7676

But besides there are lines like this:

SD,575757,777722,N/A,XDE,FREETEXT,7575

Has anyone any idea how to configure the file adapter to get it recognize the quotation marks not as field separator?

I've already tried the enclosureSign parameters but that leads to an total unconverted line.

Is it maybe possible to customize two field separators like this:

Structure.fieldSeparator - ,"

Thanks for any answer,

Christina

[Former Member]

Hi Moorthy,

unfortunately this does not help.

I configured

Structure.enclosureSign - " and

Structure.enclosureSignEscape - ""

What I get is the whole line still comma separated with the question marks in it. Actually it is like it was before it went into XI

More ideas?

[moorthy]

Did u give along with structure.fieldSeparator = ,

Structure.enclosureSign - "

Structure.enclosureSignEscape - ""

If not try along with that..just probably i am forgetting something here.

Also try to put NameA.fieldContentFormatting -= nothing..

Just check it

R/Moorthy

[Former Member]

No, it doesn't work.

I've specified now:

Structure.fieldSeparator ,

Structure.enclosureSign "

Structure.enclosureSignEscape ""

Every line without quotation marks is converted fine. Lines with quotation marks stay like in the original CSV file and the whole line is put into one XML tag (still comma separated).

Also the parameter fieldContentFormatting - nothing doesn't make a difference.

Other ideas?

[Former Member]

Hi,

Try giving enclosureSignEscape "",

Regards,

Smitha.

[Former Member]

Hi,

Just now i tried your scenario . With

ITEM.enclosureSign "

ITEM.enclosureSignEscape ""

ITEM being my structure name.

It works perfectly fine. It gives the output XML without the quotation marks.

May be i think something else is wrong with your configuration.

VaaS

[moorthy]

Hi,

Did u try with this option "enclosureConversion"

http://help.sap.com/saphelp_nw2004s/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/frameset.htm

While using enclosureSign , also use enclosureSignEscape and try it

Hope this helps,

Moorthy