|
/P# |
Meaning |
Extra Parameters: /1{Parameter1} … /n{Nth Parameter} |
|
209 |
(CSV) Pads field(s) to a fixed length by adding the ASCII character of choice |
/1 = lLength represents length of field(s) with padding /2 = sPadChar is the ASCII numerical value of the padding character /3 = bPadLeft ("TRUE" or "FALSE") Set to "TRUE" to pad left /4 = lColumn indicates the column(s) to be padded |
We will create a copy of the input file C:\CSVFiles\Simple.CSV that will be named C:\Files\SimplyPadded.csv. The output file will have padding in fields (columns) 1-3 after specifying a length of 24, will place ASCII character 35 [#] on the right side of existing data. The following syntax will do this:
ConvertXLS.EXE /S"C:\CSVFiles\Simple.CSV" /T"C:\CSVFiles\SimplyPadded.CSV" /P209 /1 24 /2 35 /3 FALSE /4 1-3
If you need all fields padded, use zero as the argument for switch /4, i.e. /4 0.