P203 (CSV) Change comma to other delimiter

/P#

Meaning

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

203

(CSV) Change from comma to other delimiter

/2 = Decimal ASCII numeric value of the character to replace the "," comma with.

For example to swap out the comma with a pound symbol "#" specify: /2 35

Special Parameters Described in Detail

/2 #ASCII Decimal value of the character to replace the comma with.

Additional Notes: This special process is used to replace the comma delimiter with a delimiter of your choice. Any valid ASCII character can be specified (1-254). For example if we swapped the comma with the pound symbol "#" (ASCII 35) the file before applying this process looks like:

Data1,Data2,Data3,Data4

After applying this process it looks like:

Data1#Data2#Data3#Data4

EXAMPLE Changing Delimiter from comma to "#"

To replace the comma with the "#" symbol within the file "D:\CSVFiles\Simple.CSV" the following syntax would be used:

ConvertXLS.EXE /S"D:\CSVFiles\Simple.CSV" /T"D:\CSVFiles\Simple.CSV" /P203 /2 35

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.