Regarding nested double quotes unmarshal issue.

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Regarding nested double quotes unmarshal issue.

Priya.Srinivasan
This message was sent securely using Zix®

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,


Our csv data look like below,


The unexpected data that we receive,


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®.

Exception.txt (5K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: Regarding nested double quotes unmarshal issue.

Michael Kay
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 <[hidden email]> 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>