On Jan 12, 2007, at 10:00 AM, Josselin wrote: > I wrote the following ruby statements.. I get the result I need , > I tried to DRY it for 2 hours without being successfull , > > d = d.gsub(/\r\n/,' ') # get rid of carriage return > d = d.gsub(/;/,' ') # replace column by space > d = d.gsub(/,/,' ') # replace comma by space > a = d.split(' ') # split into component , space as divider a = d.split(/(?:\r\n|[;, ])/) Hope that helps. James Edward Gray II