G
Guest
Hi,
I need to figure out how to format my text to include a set character length
for each field in a column. Additionally, if the text does not meet the
maximum length for the field, then I need leading zeros to make up the
difference beteen the number of characters in the text and the maximum
allowed for the field.
i.e. if I have a name such as Gray in the field and the field needs to be
exactly 13 characters then I need it to be 000000000Gray.
I need to figure out how to format my text to include a set character length
for each field in a column. Additionally, if the text does not meet the
maximum length for the field, then I need leading zeros to make up the
difference beteen the number of characters in the text and the maximum
allowed for the field.
i.e. if I have a name such as Gray in the field and the field needs to be
exactly 13 characters then I need it to be 000000000Gray.