Forum Discussion

andre_mangatal's avatar
andre_mangatal
New Contributor
7 years ago

HELP PLEASE - CSV Parser Advice Reading Delimiter In Data Fields

Good day SnapLogic Community

I would greatly appreciate your help with the following. We have a cloud pipeline reading data from a REST service and returns the data in a comma delimited string. It send the data via a pipeline execute with label “Store Transactions” and this child pipeline has a CSV Parser configured as below. A runtime error occurs because one field contains XML data as follows with also contains commas so an error is being thrown.

Is there any way that I can design the pipeline to deal with these extra commas before the line feed?

        <Policy>
            <PolicyId>5002919511</PolicyId>
            <PlanCode>LB85 1</PlanCode>
            <Status>UNDERWRITING INCOMPLETE, MISSING REQTS, ERROR ON POLICY</Status>
            <IssueDate>2019-03-15</IssueDate>
            <Mode>SEMI ANNUAL</Mode>
            <ModalPremium>6078.75</ModalPremium>
            <PremiumDueDate>1900-01-01</PremiumDueDate>
            <Quantity>1</Quantity>
        </Policy>

Thank you very much in advance!

Best regards

4 Replies

  • gremishe's avatar
    gremishe
    New Contributor

    Not really.
    In this one, the square brackets are showing up int the preview, but his REST POST worked.
    In my case I do not have REST POST. It’s just open ended JSON Generator.