I need to build a loader for my MySQL database. It will need to use load data infile. I shouldn't say need to, but that's the only way I know how to load a csv formated text file.
The file that I recieve has a field with a value in it like "LROEND256" before the csv file gets loaded into the database I would like for it to take that field and split into three fields such as, "LRO" "END" "256".
The first three letters will sometimes have a * or / in it.
The second will always be three letters.
The third will always be three to four digit number.
I guess my question is, In the loader can I have it take that field and split into three fields?
I have searched forum after forum and nothing has helped yet. Thanks in advance for all your help.
--joey
