php-db | 2001041

[PHP-DB] Only part of a field SQL From: Randall Barber (rdb55 <email protected>)
Date: 04/11/01

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:

999999
999998
999997

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

Thanks in advance,
RDB