P75 (CSV,TXT) Replace a Character

/P#

Meaning

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

75

(CSV and TXT) Replace a character but ignore what is inside of quotes

/1 = sSearchFor

/2 = sReplace

Must specify /F# with the Special Process File Type Constants

EXAMPLE 1 Replace colons [ASCII character 58] with a dash [ASCII character 45]

To replace the colon character (:) with a dash (-) in the text file located at C:\TextFiles\Letter.txt, the following syntax would be used:

 

ConvertXLS.EXE /F30 /S"C:\TextFiles\Letter.txt" /T"C:\TextFiles\Letter.txt" /P75 /1 58 /2 45

 

Note: The /F switch, indicating the file type, should always be set to /F30 regardless of whether you are using CSV or TXT file types.

The /S and /T switches specify the input and output files respectively, which in this case is the same. You can optionally keep the input file unchanged by specifying a different name or path for the output file.