P209 (CSV) Pad field to a fixed length

/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

EXAMPLE Pad fields 1-3 with # [ASCII character 35]

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.