What about those double quote?
You need to do a better job show use what you call the fields.
On Fri, Sep 24, 2010 at 3:01 PM, Ming Chen <email@example.com> wrote:
> Hi All,
> I am trying to import a client csv format data file with comma within some
> columns. Since the client won't fix their crap and the boss thinks we can
> fix it by at least manually removing the comma in the txt field.
> By checking the data, I am sure that regular expression can come to rescue
> me since there are some obvious patterns in the data. However, I am just
> know a little bit the regular expression stuff and I really need some help
> Here are some sample data:
> columns: code1, code1_desc, code2, code2_desc, code3,code3_desc,
> 111111,VANITY TOP OVAL , 31X22",4456,MARBLE FACTORY,
> The,30,Plumbing,3002,Finish Plumbing,060,Bathroom Furniture
> 22222,MIRROR 251/2X21/4X33, NLCM-2433,9250,FOREMOST ,GROUPS
> INC,30,Plumbing,3002,Finish Plumbing,060,Bathroom Furniture
> 3333,ACID ,BRUSH 1/2" 3/PK,1120,OATEY CANADA SUPPLY CHAIN
> 444,FLARED MALE AD,. 1/4X1/4 48-4B,4056,FAIRVIEW FITTINGS & MFG,
> LTD,30,,3004,Rough Plumbing
> I am sure that I can fix the csv file just by removing the comma in the 5
> code_desc columns and there are only number with comma before and after the
> desc part.