Errant commas

[TKnTexas]

Our AP master file is huge and data has been around forever. We just upgraded from the DOS_version to the Win_version (I want my DOS_version back). Back when the AP adminstrator only followed one rule, CAPS only. Commas were used:

Horton, Horton, and Smith, Inc. as an example.

I need to develop new tools to parse the data from the spooled report files. The reports have no delimiters. Just pure text. The commas in some names are skewing import. I am importing as ALL FILES. Not csv or tab when I select file type.

At end of day, every day, I spool a report of the AP Batch Edit Listing. For each invoice keyed there is only one line of important info. I can eliminate the superfluous lines. I can parse all the data into the correct fields. I can export the data to a CSV file that goes to another application to look for duplicate invoices, even if the invoice was posted to two different vendors.

My snag is the commas in the name. Each line of the spooled report is imported to a single field with each line of the report a record. In records with the commas, all information to the right of the comma is not imported.

I am using this as a Windows runtime, on XP Professional version 10v3. Any thoughts on this?

[bruceR]

You are importing as CSV; import as tab delimited.

[TKnTexas]

Doh, I hate the simple answers. lol

Thanks.