Need Regular expression to pre process CSV file
Posted on 2008-10-23
( PHP 5.2 / Apache / WinXP )
I need to clean up a CSV file line by line before I process it.
The file has been mangled by Excel.
I'm new to regular expressions so I need some help.
The CSV file is actually a .txt file which is tab separated.
What I need to do is remove any tabs, commas and single quotes that are contained within a double quote.
And also remove the double quote as well.
So I end up with a clean CSV line separated by tabs.
C05110200 "Trish, Ruducheerry" Cantonon TH18312 1973/0726
C05110200 Trish Ruducheerry Cantonon TH18312 1973/0726
Please provide a code example