Maybe this (attached) will do the trick?
On Tue, Jul 2, 2013 at 11:58 AM, Kyle Banerjee <[log in to unmask]>wrote:
> I haven't used the addins, but any real regex support should allow you to
> extract multiple matches in one shot. However, you'd still need a bit of
> code to identify the max value.
> On Jul 2, 2013 10:51 AM, "Harper, Cynthia" <[log in to unmask]> wrote:
> > I've used a couple of Add-ins for regexp in excel, but I wondered if
> > regexp had the ability to test the multiple matches in a single-line
> > expression. But I guess that does require a multiline program - I'll use
> > VB. Thanks.
> > -----Original Message-----
> > From: Code for Libraries [mailto:[log in to unmask]] On Behalf Of
> > Kyle Banerjee
> > Sent: Tuesday, July 02, 2013 11:47 AM
> > To: [log in to unmask]
> > Subject: Re: [CODE4LIB] Regular expression for maximum 4-digit number
> > AFAIK, Excel has no built in regex capabilities so you'd need to call
> > vbscript from Excel to do this.
> > In any case, you'll need to write an actual program to evaluate each line
> > since multiple values can occur in the same line. This will be easier if
> > done as text than in VBA. Besides, the data in Excel came from Mil in
> > to begin with.
> > There are many ways to do what you want, but perl would be hard to beat
> > for this use case
> > Kyle
> > On Jul 2, 2013 10:02 AM, "Harper, Cynthia" <[log in to unmask]> wrote:
> > > Is there a way to return (in Excel, if possible) the largest 4-digit
> > > number (by word boundaries) in a string? I've extracted the 863
> > > fields from Millennium for my active periodicals, and want to find the
> > > latest year in each run. I'm willing to estimate it by taking the
> > > largest 4-digit number in the string. I'm doing this in Excel. Any
> > >
> > > Cindy Harper
> > > Electronic Services and Serials Librarian Virginia Theological
> > > Seminary
> > > 3737 Seminary Road
> > > Alexandria VA 22304
> > > 703-461-1794
> > > [log in to unmask]
> > >