Format csv file

Hey i am facing issue while formating my csv file. Below is my csv file.
Jeep_30122019.zip (1.6 KB)

This link may help you,

1 Like

still facing the same problem

Hi,

Your data at address1 column in the first row seems "C/O MR, JASWANT SINGH, VILL KADAL P.O KOTI, ATHOORWALA ". However, CSV parser recognize it as 4 data, because it contains 3 commas.

So Can you change the delimiter of CSV comma to tab or semi-colon?
Or you can also get proper CSV if you can have all data surrounded by double quote.

Regards,

if we copy csv file data into notepad replace ~~ with | than again copy notepad data into excel than with shortcut key Alt+D+E ->select Delimited ->Next -> unselect TAB option and select Other option and in value fild put | then next and finish this process gives us proper data.

So, how can i implement this thing on my uipath process.