xml data

[lmit]

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

[Anonymous · Accepted solution]

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

[lmit]

Thanks shong it worked

Thanks,
Lmit

[Anonymous]

Great, thanks for your feedback!