Parsing Delimited Test Files and Placing in My_SQL DB
Posted: Thu Dec 25, 2003 8:03 pm
Ok, after browsing through the site I’ve already discover a partial solution to my question but I figure I will post it in it’s entirety and see if you geniuses can shed some light. I need to Write a program that downloads a text file, parses the file, stores it in a mysql database and then outputs it to a page.
I understand I have to write a cron to download the text file (although I do not necessarily know how) and then I have to parse. The text file may be comma space or tab delimited, I’m not sure. The end of the line is the end of the entry. Once text file is parsed I want to store each of the fields in a corresponding my_sql database. This needs to happen once every six hours or so . . . any help would be great . . . . thanks
I understand I have to write a cron to download the text file (although I do not necessarily know how) and then I have to parse. The text file may be comma space or tab delimited, I’m not sure. The end of the line is the end of the entry. Once text file is parsed I want to store each of the fields in a corresponding my_sql database. This needs to happen once every six hours or so . . . any help would be great . . . . thanks