hi i have this csv that has data in the wrong columns.
and i would like to find a way of cleaning it up.
i am guessing that there might be quotes inside the columns and this might be causing the problem?
This is the csv: http://christophersowerby.com/stock.CSV
This is an example of the problem:
If you open the csv in excel and look at the column called Stock Number you will see the unique identifiers for each product.
Now if you do a search for the Stock Number: 1002015
it is not in the correct column, it should be with the other stock numbers.
if it is extra commas or quotes in the CSV casing this, does any one know a php script to clean it up?