Import Specific Text

Grandchester

Registered User.
Local time
Today, 19:08
Joined
Jan 26, 2001
Messages
20
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
 
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
 
and second, don't post the same question in more than one place.

BL
 

Users who are viewing this thread

Back
Top Bottom