Text file import with mixed data

  • Thread starter Thread starter JHL
  • Start date Start date
J

JHL

I have a rather large text file and because of the way the data is
retrieved, some columns have alpha and numeric data. The alpha characters
will always be "NF" (without the quotes). The numeric will be in dollar
format.
When you import the only way I know of so that I do not lose the "NF"
records, is to format those columns as text. My problem is I do need to
make calculations on those other records.

All help is appreciated.
JHL
 
Check out Import Specification in Help file; you can create and store a
specification and then use it with TransferText action / method to import
data from a text file.
 
Back
Top