Skip to Content

Comma Field separator issue

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 25, 2012 at 08:21 PM

    Hi,

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

    Best Regards,

    Sagarika Mishra

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Sep 26, 2012 at 08:32 AM

    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

    Add comment
    10|10000 characters needed characters exceeded