I use Kantu Seleniun Ide to extract from webpages and save data in csv.
Kantu Seleniun Ide save all data extracted in csv with all lines merged, I need a classic format of csv with all lines separated.
I need a bat file to convert these csv with all merged lines in classic csv with separated lines for windows 7.
I would suggest that your lines are not being output merged at all but they're simply being viewed in the wrong program, notepad.exe
.
The problem is most likely that your program outputs the CSV using Unix or Mac, LF
or CR
line endings instead of Windows CRLF
.
If your file is using Unix LF
, endings, (most likely), then you could fix that by using:
Find /V ""<"test.csv">"converted.csv"
Then open converted.csv
in Windows notepad to verify the conversion.