View Full Version : Import Specific Text


Grandchester
01-11-2002, 06:49 AM
What I'm looking for is to import a .csv file into a table excluding varioous rows that don't meet my criteria. Example:
-Row's 1-5 have text which I do not want to import
-Rows 6-30 have three columns of data to import
-Rows 30-35 have text which I do not want to import.

The rows are not consistent, so I can not use row numebrs as a variable. I need to have something that will be able to diferentiate between the data I want to import and do not based on their substance. The columns are fixed width and have a specific number of characters if that will help. Any takers? Thanks,

Grandchester

pdx_man
01-11-2002, 02:36 PM
I would first just import the data into a generic table. TransferText in Help.

Then delete the rows (or append the needed rows to another table) based on -->
I need to have something that will be able to diferentiate between the data I want to import and do not based on their substance

boblarson
01-11-2002, 04:01 PM
and second, don't post the same question in more than one place.

BL