Our Xerox production printers export a log in ':' delimited format.  
No big deal, except that each field has a tag like so:

Job ID = 999999
Job ID = 999998
Job ID = 999997

See what I mean?

I have simply imported the whole CSV file into Access and was now wondering if I could 
do the following?
Pull everything out of the field AFTER the '=' sign.

SELECT FIELD1, FIELD3, FIELD10 FROM ImportTable WHERE FIELD1=' everything after the = 
sign ' AND FIELD3=' same idea ' AND FIELD10=' same idea '

So when I execute the query all I get for Job IDs is:


Is there a way to do this in the query?  I am totally inexperienced.  

Thanks in advance,

Reply via email to