HELP! Extract everything between ""

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
There are over 100,000 records. I think I need a subroutine to loop through
them all.
 
You could split it two and let Excel do it - Excel can handle 65K records.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extract specific information from the body of outlook mail to an Excel File using VBA 0
Search/Extract Specific Data from all fields in a table 1
extraction. 2
Multiple combinations in form validation rule question. 2
Access 2003 Crashes and corrupt ADP projects 13
Extracting audio from an Access Database 1
Extracting keywords from a string (memo field) 4
Spreadsheet import/update to normalised database. 4

Back
Top