Flat Files recognizing Numeric vs Char fields
Posted on 2003-11-03
I am creating an ASCII file, which will be transmitted to an external source via FTP. In the file, if field lengths are shorter then what the file layout requires, then I need to pad either with trailing spaces or leading zeros depending on the data type.
My question is this, when I have a numeric field, the leading zeros are removed, and in many cases I need them to exist. So, if I use a string field and force a right justify by padding leading zeros, will there be anyway to tell when the data is extracted by the external source that it was not a numeric field?