From: Nuralanur@...
Date: 2006-07-10T07:39:20+09:00
Subject: Re: CSV::IllegalFormatError (Need to club data entry person)

-------------------------------1152484751
Content-Type: text/plain; charset="US-ASCII"
Content-Transfer-Encoding: 7bit

Can you use this:
 
line = "\"NAME\",\"610 \"A\"  STREET\",\"STATE\",\"POSTAL_CODE\""
regexp=/(?=[^,])"|"(?=[^,])/ # (?= is for  maintaining the character that is 
not  a comma)  
a=line.gsub(regexp,'\1'+"'"+'\2')  # \1, \2 are the first and second  matches 
in brackets
regexp=/'([A-Z])'/ # if the address is "610 A  street"
b=a.gsub(regexp,'"'+'\1'+'"')
 
p line
p a
p b

Best regards,
 
Axel 

-------------------------------1152484751--