Search and Replace

[Anon]

Here is my problem. I have a text file that has over 1000 records. Each FIELD isn't terminated, the FIELDS are of a Fixed amount of Chars. (Ex. Firstname String * 30, etc...).

In total, there are 1000 chars per record. With over 1000 records.... well you can see thats alot of counting.
I need to import this file into a Mysql table. I have tried PhpMyAdmin, but I don't know how to set the Field Terminators and Line terminators, when everything is just based on spaces of chars. Here is a small example:

• = SPACE

Firstname***Lastname******Street*********City******ZIPTELE****

Basically, I'm not even sure where to begin. I thought of maybe a PHP Script that can allow me to set variables and do a /n for every 1000 spaces (ie. 1 Record) but I'm not sure how to terminate the fields in those records in order to import into mysql table.

ANY Help would be GREATLY Appreciated!

Thanks in Advance!
BjM

[matto]

php should cope with 1000 records like this, try splitting each line with substr.

if the you fear the script could time out (this could happen, but when I did such a thing, it could take about 5000 records doing an insert for each one), set a higher time limit for script execution, see the function set_time_limit.