locked
how to parse a csv flat file with double quotes included in biztalk server 2006 RRS feed

  • Question

  • HI,

    I am facing a problem when processing one of the flat file record.

    The incoming file format  is CSV, in that first element is agent name , the agent name is coming in quotes, there is a comma delimiter in that quotes when I am trying to generate the schema its taking that delimiter as extra element. Any suggestions are appreciated and its urgent for me.

     

    Example: "R.M. Beasley & Associates, Inc."  

    There is a delimiter between R.M. Beasley & Associates and Inc

     when i process this single element its taking as two columns one is R.M. Beasley & Associates  and another column is Inc

     

    Friday, December 5, 2008 4:37 AM

Answers

  • On this field set:

    Wrap Character Type = Character

    Wrap Character = "

    Friday, December 5, 2008 8:46 AM
    Answerer