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