Skip to Content
0
Dec 17, 2018 at 07:23 PM

Issue With Comma While Generating CSV File in SFTP Adapter

401 Views

Hi Experts,

I am having a requirement where we have to convert xml file to CSV format using SFTP adapter. so i am using the below MTB for that and CSV file generated successfully. But facing the issue with comma in a field.

Example : - <row> <ExpenseType>Taxi, Train and Tolls</ExpenseType> </row>

O/P csv file the filed ExpenseType is spiting as Taxi onecolumn and Train and Tolls in the next column.

Can you please help me on this.

Using the below MTB :

Regards,

Azeem

Attachments