hi all,
i have a big problem and i don't know what to do. This is the thing: i have a flat file with 26 fields, which are separated by ';'
by example, i have this:
Peter;Smith;2005;200508; .........
if the lengths of the fields are:
field 1: Alphanumeric[10] - field 2: Alphanumeric[10] - field 3: numeric[8] - field 4: numeric [10] - etc ....
i want this:
Peter ;Smith ;00002005;0000200508;
I need giving format to each field, to get the length of each field, which is established. if the field is numeric, i must fill with zeroes to the left of the number, until the length of the field is completed. if the field is alphanumeric, i must field whit blank spaces to the rigth of the value.
an important thing, is what i must keep the field separator (
.
how can i do thatΏ?
please, help me
thanks for your help