From: Todd Burch <promos@...>
Date: 2007-07-17T21:52:11+09:00
Subject: Re: regex help please - parsing an Excel Range

Phil Meier wrote:

> You can have this in one RegEx:
> 
> addr = "$G$28:$I$28"
> addr =~ /:\$*([A-Z])+\$*(.*)$/
> puts "row=#{$2}, col=#{$1}"   # -> row=28, col=I
> 
> An addr = "G28:I28" would also be accepted by the RegEx.

Works perfect Phil.  Thanks!  Todd

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