Mysqlimport complex question

2006-10-04 Thread Scott Hamm
/* OBJECTIVE: INPUT: E524541015.txt:20061004|,535,999|Scot|Hamm|,410|||101 Walter Rd|Dover|MD|76709|,041| WHERE error (,###) can be in any fields *AFTER* the first | char DESIRED OUTPUT: filename: E524541015.txt ord: 20061004 error: 535 error1: 999 error2: 410 error3: 041 error4:

Re: Mysqlimport complex question

2006-10-04 Thread Christian Hammers
On 2006-10-04 Scott Hamm wrote: OBJECTIVE: INPUT: E524541015.txt:20061004|,535,999|Scot|Hamm|,410|||101 Walter Rd|Dover|MD|76709|,041| ... Been trying to get mysqlimport to use these characters to no avail, how do I get around to it? I can't answer your question but think that you're