I need to get some guidance on a project. I have to extract unstructured data from a
.CSV file and reformat the data to import into MSSQL.
The unstructured data is basically in some kind of sub summary report. Note: the files
will include a range from 1 to 12 months of information (month to date). Four
different .CSV files would need to be reformatted at the same time. The file size for
one is about 1.7 MB and containing roughly around 21,115 rows of data in each.
Would PHP be a good program to use for this project? Has anyone had to reformat
unstructured data to insert into a database? If anyone has any suggestions or
examples please let me know. J
I was thinking about importing the data into an array then parsing through the
information with multiple if statements then using SQL to insert the data into a
database. This will be my first PHP parse project so any examples and suggestions to
get me started would be greatly appreciated. A small sample of the data structure is
below:
Thank You,
Sophia
[EMAIL PROTECTED]
/WCS37 /WCS9 /WCS9 WCS9
RETAIL REGIS PAG E1
VEHIC LE TYPE CAR &T
AREA: PLACE
MONTH MONTH MONTH
OCT. SEP. AUG
2003 2003 2003
GROUP MAK MDL
----- --- --- ----- ----- -----
SPTY COUP AU RSX 3 4 8
CCT CAR FORD FC 4 1 7
REPORT DATE: 1/12/01
RETAIL REGIS PAG E1
VEHIC LE TYPE CAR &T
AREA: PLACE2
MONTH MONTH MONTH
OCT. SEP. AUG
2003 2003 2003
GROUP MAK MDL
----- --- --- ----- ----- -----
SPTY COUP AU RSX 1 7 3
CCT CAR FORD FC 2 2 5
REPORT DATE: 1/12/01
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
