Re: [PHP-DB] Only part of a field SQL

2001-04-11 Thread W Clements
MAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 11, 2001 4:43 PM Subject: [PHP-DB] Only part of a field SQL Our Xerox production printers export a log in ':' delimited format. No big deal, except that each field has a tag like so: Job ID = 99 Job ID = 999

Re: [PHP-DB] Only part of a field SQL

2001-04-11 Thread B. van Ouwerkerk
>Is there a way to do this in the query? I am totally inexperienced. Why not remove the part you don't want to import.. very easy in Access. Bye, B. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTEC

[PHP-DB] Only part of a field SQL

2001-04-11 Thread Randall Barber
Our Xerox production printers export a log in ':' delimited format. No big deal, except that each field has a tag like so: Job ID = 99 Job ID = 98 Job ID = 97 See what I mean? I have simply imported the whole CSV file into Access and was now wondering if I could do the following?