Parsing data from flat file to db table

[chadrt]

I currently use a script that is pretty much all over the place but it works by downloading a .zip file then unzipping it, then it loads that file into database tables.  It uses a line like this in a .sql file

 

load data local infile './file.dat' into table AM fields terminated by '|';

 

In this case it is quite easy to perform the functions needed however I have another file that is formatted differently its raw contents are formatted like this:

 

Start Column    Field Length

1                        6

8                        35

44                      35

80                      70

 

Anyway I wont print the rest of them but that is the basics!  The file is a flat text file and I would like to populate a db table with its contents can anyone help me out with the format for doing this?

 

Chad

 

 

[fenway]

Well, substring will help you grab each field -- but you'll have to store the output of that somehow, somewhere.