Sorry I jumped the gun. Here is the code, I need to save inventoryconverted.csv as inventoryconverted-"date and time".csv
<?php
$file_handle = fopen("xrwholesalePipeDelimited.txt", "r");
$converted = fopen("inventoryconverted.csv","w");
while (!feof($file_handle) ) {
$line_of_text = fgets($file_handle);
$column = explode('|', $line_of_text);
//Remove manfacturers used in category field and remove all un neccessary colons//
$search = $column[12];
$subject = $column[3];
$replace = "";
$replace3 = ";;";
$search2 = "Bulk Packaged Products;";
$search3 = "Bulk Packaged Products";
$search4 = "Retail Display Packaged;";
$search5 = "Retail Display Packaged";
$search6 = array(';;;;;;;;',';;;;;;;',';;;;;;',';;;;;',';;;;',';;;',';;');
if ($search!="0"){
$removed = str_replace($search,$replace,$subject);
$nopackaging = str_replace($search2,$replace,$removed);
$nopackaging1 = str_replace($search3,$replace,$nopackaging);
$nopackaging2 = str_replace($search4,$replace,$nopackaging1);
$nopackaging3 = str_replace($search5,$replace,$nopackaging2);
$nocolon=trim($nopackaging3, ';');
$subject = str_replace($search6, ';',$nocolon);
$final = str_replace(';',';;',$subject);
}
$output= array($column[0],$column[1],$column[2],$final,$column[4],$column[5],$column[6],$column[7],$column[8],$column[9],$column[10],$column[11],$column[12],$column[13],$column[14],$column[15],$column[16],$column[17]);
fputcsv($converted, $output, '|');
}
fclose($file_handle);
fclose($converted);
}
?>
