HELP! Extract everything between ""

J

jmenche

Hi,

I imported a large text file and every value in every field is enclosed in
quotes (e.g. "Southwest","1000", etc.). Doing a search and replace crashes
my machine. Is there a way in a query to extract between the quotes???

Thanks for any help
 
K

KARL DEWEY

Try doing it in smaller chuncks. Build a select query and set for top 25 or
100.
In design view of the query on the tool bar is pull down defaulted to All.
You can also put in any number you want like 50 or 250.
 
J

jmenche

There are over 100,000 records. I think I need a subroutine to loop through
them all.
 
V

Van T. Dinh

The more efficient way is to re-import and specify that the Text delimiter
is double-quote ". This way, the import process will get rid of the
double-quotes for you.
 
Top