Captain Ned wrote:We get a text file with about 90 or so fields in a flat file with thousands of lines, representing the bank's loan portfolio and the key data we want to look at. This is supposed to seamlessly import into this Access run-time app. If there's a single character in a numeric field the entire thing barfs and doesn't even give you the courtesy of telling you what line in the file is causing the problem. Hence, a week spent going through the file to ensure no data type errors, converting it to Excel to fix other numeric errors (each bank main processing platform has its own little ways of not giving us what we really asked for), then converting it back to a FIXED-WIDTH (really, you couldn't use delimited fields ) text file to import.
Sounds like something that an AWK (and I'll kill anyone who mentions PERL) script could help automate significant parts of the job. At least it could validate the data fields and output to fixed-width.