FCC Issue in comma separated file

[Former Member]

Hi

I am working on file to file scenario. I need to pick the comma separated file. Here the issue is description field values are coming like "ABC Supermarket,XYZ"(value in double codes with commas). If i use the field separator as ,(comma) then XI treats as two field values instead of single field value.

Please suggest me how can i pick this type of file by using FCC.

Thanks

Priya

[Former Member · Accepted solution]

Hi Priya,

According to me the solution is to set the Text delimiter to ".

If you specify xml.enclosureSign=“ and xml.enclosureSignEsc=““, text enclosed in quotation marks is transferred unchanged and the quotation marks are removed.

If the escape character for a quotation mark (““) occurs in the text itself, it is replaced by the quotation mark during the transfer.

If this is not handle by this solution, I think its a complex issue which can be solved by using mapping.

Regards,

Sagarika

[Former Member · Accepted solution]

this is a very simple and common req. which can be easily handle using FCC parameters..so no java mapping and all is needed.

Thanks

Amit Srivastava

[Former Member]

Hello,

Use NameA.enclosureSign  parameter:

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

Thanks

Amit Srivastava