From: Sean Clark <smc7000@...>
Date: 2006-07-10T07:18:43+09:00
Subject: Re: CSV::IllegalFormatError (Need to club data entry person)

Bira wrote:
> line.gsub(/[^,]"[^,]/,"'")

Bira, I'm testing your idea with the below script but I'm having 
problems. Thanks for the start though.
TEST PROGRAM:
line = "\"NAME\",\"610 \"A\" STREET\",\"STATE\",\"POSTAL_CODE\""
puts line
# if double quote not preceeded by a comman and not followed
# by a comma, then replace the quotation with a single quote.
new_line = line.gsub(/[^,]"[^,]/,"'")
puts new_line

OUTPUT:
"NAME","610 "A" STREET","STATE","POSTAL_CODE"
"NAME","610'" STREET","STATE","POSTAL_CODE"


Any ideas regular expression masters?

-- 
Posted via http://www.ruby-forum.com/.