|
/P# |
Meaning |
Extra Parameters: /1{Parameter1} … /n{Nth Parameter} |
|
204 |
(CSV) Remove empty lines |
NONE |
This special process is used to remove empty lines from a CSV file. Empty lines constitute those lines that do not have any data between the ",". Blank characters are not considered data. For example the file before applying this process looks like:
Data1,Data2,Data3,Data4
,, ,
Data1,Data2,Data3,Data4
Data1,Data2,Data3,Data4
After applying this process it looks like:
Data1,Data2,Data3,Data4
Data1,Data2,Data3,Data4
Data1,Data2,Data3,Data4
To remove all empty CSV lines within the file "D:\CSVFiles\Simple.CSV" following syntax would be used:
ConvertXLS.EXE /S"D:\CSVFiles\Simple.CSV" /T"D:\CSVFiles\Simple.CSV" /P204
The /S and /T switches specify input and output workbook respectively, which in this case is the same workbook. You can optionally keep the input file unchanged by specifying a different name or path for the output file.