Help: importing ";" denoted .txt file into a DB.

[camarosource]

Specs:

1. File is called rpo_list.txt
2. Located in same directory as import.php
3. Database is "camaro92_RPO"
4. Table is RPO_INFO, fields are "RPO_CODE" & "DESCRIPTION".

The contents of the file has 2 pieces of info for each line seperated by a ";".

ie.

L98;5.7-liter v8 350-cid engine for 3rd generation camaro's
LS1;5.7-liter v8 engine for 4th generation camaro's

When the script runs, it would look at the first line and see "L98". Would then import this into the RPO_CODE field of RPO_INFO table. It would then note the ";" which tells it that the next info is for the next field and so the "5.7-liter v8 350-cid engine for 3rd generation camaro's" would be imported into field "DESCRIPTION" of table "RPO_INFO".

It would then repeat for each line down the script.

Can anyone please help me? Perhaps they can write a small script that will do this? I have a list of over 4,100 RPO codes and need a way to import it.

Thank you sincerely for all your help.

[bad76]

Hi,
it's a standard format, the CSV, and there are standard function:

one way may be this:
$data=explode(";",file(rpo_list.txt));

This make an array data[] with a value for cell.

From this you can figure out how to continue...