P207 (CSV) Remove control characters if they exist command line example

/P#

Meaning

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

207

(CSV) Remove control characters if they exist the data.

NONE

Additional Notes: Sometimes unwanted control characters can make their way into the data. Use this special process to remove any unwanted control characters. This does not include the carriage return and line feed a the end of each line of course.

 

EXAMPLE Remove control characters

To remove control characters in file D:\CSVFiles\Simple.CSV, the following syntax would be used:

 

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

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.