Comma Field separator issue

[former_member234749]

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 "PM SERVICES - ERFTHU, NE.  JENMARKET"(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.

How do i overcome this problem. 

Sample file:

SA,10000105,KING,ANDERSON,"PM SERVICES - ERFTHU, NE.  JENMARKET",SVGN,BNSF,ACTV,Y,ENG,G Dodge

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

Thanks

[Former Member · Accepted solution]

Hi,

You can use  xml.enclosureSign=" and xml.enclosureSignEsc=" " in your FCC which will solve the above issue.

Best Regards,

Sagarika Mishra

[former_member234749 · Accepted solution]

Thanks for quick response!

in the description field value "PM SERVICES - ERFTHU, NE.  JENMARKET". When XI process using the comma separator it separates the field description since the field value comes with an comma after ERFTHU.

Please suggest me how can i handle this.

Thanks

[Former Member · Accepted solution]

Hi,

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.

Best Regards,

Sagarika

[anupam_ghosh2 · Accepted solution]

Hi SAP PI,

                       Could you post the FCC configuration  of the communication channel, which you configured. Use of parameter "enclosureSign" should be enough to remove the problem. If this not working then need to check the various parameters you have set in FCC.

Regards

Anupam

[former_member190624]

Hi,

If you are using fixed field length value , no need to use field separator. Below  document will help you understand more .

http://help.sap.com/saphelp_nw04/helpdata/en/e3/94007075cae04f930cc4c034e411e1/content.htm