Import Specific Text (1 Viewer)

Grandchester

Registered User.
Local time
Today, 07:29
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
 

pdx_man

Just trying to help
Local time
Yesterday, 23:29
Joined
Jan 23, 2001
Messages
1,347
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

Smeghead
Local time
Yesterday, 23:29
Joined
Jan 12, 2001
Messages
32,059
and second, don't post the same question in more than one place.

BL
 

Users who are viewing this thread

Top Bottom