Pipe delimted text file

[rowan_trimmer]

I wonder if anyone can help. I have a simple text file with 20 fields in it seperated with the pipe symbol. Does anyone have any php code that would enable me to insert this into a MYSQL database ?

Many thanks in advance.

[sarahk]

is this a one off file upload?

if so, get it into Excel which will do a good job of sorting out the columns. Then on the next available column have somehting like:

='insert into mytable values (null, '" + A1 + "','" + A2 + "');"

assuming an autoincrementing id
and build it up to include all the fields - I just got lazy

then copy this into a text file, and put it straight to mysql.

If this is a regular upload you'll need to read each line of the file, explode it into an array and then build the insert from the array.

hope this helps.

[rowan_trimmer]

Hello Again,

It is not a one off import that I am trying to do. I am trying to automatically read in a pipe delimited text file using php into a mysql database. I would really appreciate it if anyone has a php script to do this. The text file has 20 fields

Many thanks in advance.