I am having trouble with getting a field to right-justify and fill empty any spaces to the left with zeros.
example: (always an 11 character field) when entering 1234.12, I need the data in the field to be 00001234.12 or if entering 123456.12, then I need the field to contain 00123456.12 instead.
It's easy to accomplish this in the format field, I just enter !*0 in the format box and the result looks exactly like what I am looking for. HOWEVER, I need to be able to Export to Text File the data and have it export as formatted, with the zeros to the left of the number. (Unfortunately Format of course only changes display formatting, not the actual data in the field).
Anyone know how to make the data actually fill the field as indicated in example above?
Thanks!!
example: (always an 11 character field) when entering 1234.12, I need the data in the field to be 00001234.12 or if entering 123456.12, then I need the field to contain 00123456.12 instead.
It's easy to accomplish this in the format field, I just enter !*0 in the format box and the result looks exactly like what I am looking for. HOWEVER, I need to be able to Export to Text File the data and have it export as formatted, with the zeros to the left of the number. (Unfortunately Format of course only changes display formatting, not the actual data in the field).
Anyone know how to make the data actually fill the field as indicated in example above?
Thanks!!
