Project Detail

Description

Hi I need a PHP or Perl script to read a CSV file and to write out a Tab Delimited file with 3 static fields added to each record.

It needs to handle a large number or records (About 10,0000)

The final Tab delimited file also needs to have a tab delimited header line with the field names.

Here is an example of what I need.

Source file.
------------
"ACR ELECTRONICS","PARTS",10024,10024.gif,24.38,0.1,"ACR 55W/24V LAMP FOR RCL-100 SERIES SEARCHLIGHT",""
"ACR ELECTRONICS","LIGHTS - SPOT/FLOOD/UNDERWATER",10025,10025.gif,82.50,1.0,"ACR URP-102 POINT PAD ONLY FOR RCL-50/100 SERIES",""
"ACR ELECTRONICS","PARTS",10026,10026.gif,14.38,0.0,"ACR 55W/12V LAMP FOR RCL-50 SEARCHLIGHT",""

Final File
v_manufactures_name v_catagories_name_1 v_products_model v_products_imagev_products_price v_products_weight v_manufactures_name v_tax_class_title v_status EOREOR
ACR ELECTRONICS PARTS 10024 10024.gif 24.38 0.1 ACR 55W/24V LAMP FOR RCL-100 SERIES SEARCHLIGHT Taxable Goods Active EOREOR
ACR ELECTRONICS LIGHTS - SPOT/FLOOD/UNDERWATER 10025 10025.gif 82.5 1 ACR URP-102 POINT PAD ONLY FOR RCL-50/100 SERIES Taxable Goods Active EOREOR
ACR ELECTRONICS PARTS 10026 10026.gif 14.38 0 ACR 55W/12V LAMP FOR RCL-50 SEARCHLIGHT Taxable Goods Active EOREOR