P204 (CSV) Remove empty lines

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

EXAMPLE Remove Empty Lines

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.