Assign number sequence to different fields

[aas1611]

Hallo,

I have the following data in a text file:

665577338811022005-08-15100500001410285711 10
.
.
etc

I want to export this data to a MySQL table and separate them into different fields, so it looks like this:

Field1 Field2 Field3 Field4 Field5
66557733881102 2005-08-15 10050000 1410285711 10
.
.
etc

Is it possible to do this in any possible way?

Any suggestions/thoughts will be appreciated. Thanks!

 

[kenrbnsn]

Since it looks like you are using fixed length fields, your best bet would be to use the substr() function (see <

http://www.php.net/substr>).

Ken