Error in csv output

[harsha384]

Hi All,

I am creating pipe-delimited csv output. Output tool configured accordingly ( | ) .

One of the column has value like -

abc;def;ghi;xyz

Now when I open the written csv file, my count of rows increases because above column splits into rows like -

abc

def

ghi

xyz

While other columns are delimited properly based on | seperator.

Can anyone suggest?

Thanks

Harsh

[grazitti_sapna]

Hi @harsha384 , seems to work fine for me as well.

If you could provide us a sample workflow, we can investigate the issue and provide the solution.

Thanks.

[harsha384]

Hi @atcodedog05 ,

Thank you for your response.

Unfortunately it didnt worked for me. 

My data size is around 4k records.

One of the column has value like

         Col A                                                           Col B

" #xyz@aa.com; def@vv.com;xyz                        test

Now Col A is getting split into rows which I don't want (My requirement) . My delimiter is pipe | 

Inspite of putting delimiter as | , my records are getting split into rows based on ; as mentioned above

Any reason why or any other solution it?

Thanks

Harsh