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