P207 (CSV) Remove control characters if they exist

/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 linefeed 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.