topic Re: xml data in Talend Studio

xml data

lmit — Fri, 21 Feb 2020 07:31:41 GMT

Hi All,

I have a table which has xml format as data for one of the column in the table.

for example:

table

col1|col2|col3...

1|<xml version>..|xxxx

I want to store the data in csv file and later load the data in other table using that use.

When am storing the data in csv , the data in splitting because of the xml format for one column, how do i process it

Thanks in advance

lmit

Re: xml data

Anonymous — Fri, 21 Feb 2020 10:17:41 GMT

Check the 'CSV options' box in the advance setting panel of tFileOutputDelimited, and add double quotes to the values. Let me know if it fixes the splitting issue.

Regards
Shong

Re: xml data

lmit — Sat, 22 Feb 2020 18:55:21 GMT

Thanks shong it worked

Thanks,
Lmit

Re: xml data

Anonymous — Mon, 24 Feb 2020 01:34:12 GMT

Great, thanks for your feedback!