You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@camel.apache.org by "Priya.Srinivasan" <Pr...@cioxhealth.com> on 2019/07/24 13:33:40 UTC

Regarding nested double quotes unmarshal issue.

Hi,

We are working with apache camel for past 4 months. Here, we unmarshal a csv file and perform some operation with that data.

The problem we are facing now is, while unmarshalling a csv file we are getting a particular column with nested double quotes value. Due to that, the csv file parsing fails and throws exception.


The piece of code to unmarshal csv is,

[cid:417c1e38-de27-49dd-9ed1-c4e07c05259f]

Our csv data look like below,

[cid:f71aab81-b854-42b2-9d98-86666a8304aa]

The unexpected data that we receive,

[cid:4e0965b6-3bfb-47c1-9615-e950134253f4]

The Data "lastname "5"" has nested double quotes. The data cannot be changed since we receive it from client feed.


The exception we are getting while unmarshalling the csv file is attached with this mail.


Kindly respond us as soon as possible.

Thanks in advance.


Regards,

Priyadharshini S.





This message was secured by Zix(R).

Re: Regarding nested double quotes unmarshal issue.

Posted by Michael Kay <mi...@saxonica.com>.

How can anyone on this list possibly help you? If your client sends you unreadable data, that's something you need to sort out with your client. What would you do if they sent you a cheque that you couldn't cash? Send it back and ask them to correct it.

Michael Kay
Saxonica

> On 24 Jul 2019, at 14:33, Priya.Srinivasan <Pr...@cioxhealth.com> wrote:
> 
> This message was sent securely using Zix® <http://www.zixcorp.com/get-started/>
> Hi,
> We are working with apache camel for past 4 months. Here, we unmarshal a csv file and perform some operation with that data.
> The problem we are facing now is, while unmarshalling a csv file we are getting a particular column with nested double quotes value. Due to that, the csv file parsing fails and throws exception.
> 
> The piece of code to unmarshal csv is,
> <image.png>
> Our csv data look like below,
> <image.png>
> The unexpected data that we receive,
> <image.png>
> The Data "lastname "5"" has nested double quotes. The data cannot be changed since we receive it from client feed.
> 
> The exception we are getting while unmarshalling the csv file is attached with this mail.
> 
> Kindly respond us as soon as possible.
> Thanks in advance.
> 
> Regards,
> Priyadharshini S.
> 
> 
> 
> 
> 
> This message was secured by Zix <http://www.zixcorp.com/>®. <Exception.txt>