Not sure what you're trying to do, but there's probably a simpler way. eg: - Use cfhttp to read the CSV file, and that will handle quoted values. - Use Excel to save as a tab-delimited file, so you don't need to worry about commas.
On 7/5/07, Zombie Lucipher <[EMAIL PROTECTED]> wrote: > > My source string is : > 1 , 2 , 3 , 4 , 4"a,b,c" , "5 a,b,c" , 6 > x x x x x x > What I am looking for is all "commas" except when they > are in between double quotes. > So the matches should correspond to the x's above. > > What I am trying to do is to parse a csv file to get > the all the columns created using MS Excel. But > MSExcel allows users to have commas inside a cell. And > they do that by putting quotes around it. > > Thank you > -Manoj > > > > > ____________________________________________________________________________________ > Park yourself in front of a world of choices in alternative vehicles. > Visit the Yahoo! Auto Green Center. > http://autos.yahoo.com/green_center/ > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/RegEx/message.cfm/messageid:1046 Subscription: http://www.houseoffusion.com/groups/RegEx/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.21
