P202 (CSV) Surround/Pad fields with spaces

 

/P#

Meaning

Extra Parameters: /1{Parameter1} … /n{Nth Parameter}

202

CSV file, Surround/Pad field with spaces

NONE

This special process is used to surround each field of a CSV file with space characters, " ". For example the file before applying this process looks like:

 

Data1,Data2,Data3,Data4

Data1,Data2,Data3,Data4

After applying this process it looks like:

 

Data1 , Data2 , Data3 , Data4

Data1 , Data2 , Data3 , Data4

EXAMPLE Surround field with spaces

To surround each data field within the file "D:\CSVFiles\Simple.CSV" with spaces the following syntax would be used:

 

ConvertXLS.EXE /S"D:\CSVFiles\Simple.CSV" /T"D:\CSVFiles\Simple.CSV" /P202

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.