Add limit to a string
Posted on 2011-04-20
I am outputting values from a excel spreadsheet, but what I would like to know is how to place constraints on the output for string limits. I need to have the spaces show up in the output as part of the limit because the data in the excel spreadsheet may not be the full max limit, but I need to account for spaces
I read each column as such:
strA = (oSheet.Cells(iRow, 1).Value) 'Transaction Key
and output in this manner:
oOut.WriteLine strA & "" & strB &
I need my text file to look like this..
If string A had a limit of 10, but it had 3 characters the output should be "123 ".