Project Detail

Description

I need a php script coded to reorganize data fields into the format I want. The data is in various formats, so it would use regular expressions to do what I need done. Some of the data is comma delimited, some will be tab delimited. Here is some sample data that I will import, and have the script properly format. I have replaced the email addresses with EMAIL_GOES_HERE, because GAF doesnt allow me to post email addresses in the description:


EMAIL_GOES_HERE Naomi Ord PO Box 800451 Toccoa Falls GA 30598 US 10/19/1981 04/25/2008 20:04 64.37.69.160 getyourgift F 7062826045
EMAIL_GOES_HERE Christina Fox 820 Lawrence Ln Newtown Square PA 19073 US 02/07/1950 04/25/2008 23:04 63.150.137.36 getyourgift F 6106889002
Theresa,E Fagin,EMAIL_GOES_HERE,35 QUAIL WOODS DR,CHELSEA,MA,2150,6174617007,1/6/2008 0:00,65.167.107.40
Diane,Gamelin,EMAIL_GOES_HERE,16 CALIFORNIA ST APT C1,BRENTWOOD,NY,11717,6312358640,1/6/2008 0:00,64.38.229.136
Anne,Dapore,EMAIL_GOES_HERE,1957 Lilac ln,GRAPEVINE,TX,76051,2145738206,1/17/2008 5:39,71.123.235.236,,,,,,,,,,,,
mary,thibdoaux,EMAIL_GOES_HERE,186b senator circle,houma,LA,70363,9858600420,1/17/2008 1:27,75.65.135.138,,,,,,,,,,,,
EMAIL_GOES_HERE,Jason,Gentry,1251 County Road 672,,Devine,TX,78016,830-663-3157,75.105.96.85,Jan 3 2008 12:58:00
EMAIL_GOES_HERE,Charles,Brodie,2440 Coralwood Drive,,Decatur,GA,30033,404-634-3519,66.56.30.109,Jan 3 2008 12:57:00
Deborah,Nunn-Persley,EMAIL_GOES_HERE,5124 Roberta Drive,Fort Wayne,IN,46806,2604477377,4/10/2008, 2:26,168.102.16.177
Cristal,Valenzuela,EMAIL_GOES_HERE,42600 Acacia Ave.,Hemet,CA,92544,9512608915,4/9/2008, 5:32,71.110.21.177
GEORGE,OSBORN,2816 N. MATTHEWS RD.,BRYANS RD.,MD,20616,EMAIL_GOES_HERE,3016432223,,1/25/2008 07:57:42,206.182.199.78,http://www.evelynnesbit.com
KIM,MILLER,174WEST SECOND MT. ROAD,POTTSVILLE,PA,17972,EMAIL_GOES_HERE,,,2/13/2008 12:05:06,207.165.5.5,http://www.sltrib.com


I want the data reorganized into 9 fields, comma delimited:

First Name,Last Name,Email Address,Address,City,State,Zip,Date/Time Stamp,IP Stamp

All other fields should be discarded. In some cases, the date and time stamps are in two different fields, so these fields will need to be combined into one field.

I want a webbrowser GUI, and I want to upload one compressed rar/zip/tar file (which will contain several .txt and .csv files of 100,000 records each). The script will uncompress that file into a folder, and process each file one at a time, and display a progress stat in the browser (Processed File 1 of 2000 files). The script will output the correctly formatted files into a new folder. When it is finished processing the files, the script will then compress (tar/rar/zip) all the processed files into one file, and display a link to download them. It will also display an option asking if I want to delete the original uploaded source data files. I need this done ASAP.