/P# |
Meaning |
Extra Parameters: /1{Parameter1} /n{Nth Parameter} |
201 |
CSV file, Surround field with quotation marks |
NONE |
This special process is used to surround each field of a CSV file with quotation marks. For example the file before applying this process looks like:
Data1,Data2,Data3
Data1,Data2,Data3
After applying this process it looks like:
"Data1","Data2","Data3"
"Data1","Data2","Data3"
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" /P201
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.