 |
 |
Thanks for the advice everyone. This is all helpful stuff that I need to spend some time with. On Thu, Jul 9, 2015 at 3:38 AM, Kool,Wouter <[log in to unmask]> wrote: > I also recommend this site: http://www.regular-expressions.info/ > If you do not want to work inside MSWord and want to use only regexes not > xpath, you could of course do something like: > > <italics>.*[A-Z ,;:]+.*</italics> > > But, depending on your environment, you might be troubles by newlines in > the data (regex engines tend to chunk your data, and they tend to use > newlines by default). > > If you just want to list the titles you could grab the title proper like: > > <italics>.*([A-Z ,;:]+).*</italics>. The part between ( and ) is then > usually accessible as $1 (in a language like Perl) or \1 (in a text editor). > > Wouter > > > > -----Original Message----- > From: Code for Libraries [mailto:[log in to unmask]] On Behalf Of > Harper, Cynthia > Sent: woensdag 8 juli 2015 19:51 > To: [log in to unmask] > Subject: Re: [CODE4LIB] Regex Question > > I like this regex add-in for Excel: > http://www.codedawn.com/index/new-excel-add-in-regex-find-replace > Cindy Harper > > -----Original Message----- > From: Code for Libraries [mailto:[log in to unmask]] On Behalf Of > Kyle Banerjee > Sent: Tuesday, July 07, 2015 6:22 PM > To: [log in to unmask] > Subject: Re: [CODE4LIB] Regex Question > > For clarity, Word does regex, not just wildcards. It's not quite as > complete as what you'd get with some other environments such as OpenOffice > Writer since matching is lazy rather than greedy which can be a big deal > depending on what you're doing and there are a couple other catches -- > notably no support for "|" -- but it's reasonably powerful. There is no > regexp capability in Excel unless you're willing to use VBA. > > kyle > > On Tue, Jul 7, 2015 at 1:10 PM, Gordon, Bonnie <[log in to unmask]> > wrote: > > > OpenOffice Writer (or a similar program) may be useful for this. It > > would allow you to search by format while using a more controlled > > regular expression than MS Word's wildcards. > > > > -----Original Message----- > > From: Code for Libraries [mailto:[log in to unmask]] On Behalf > > Of Matt Sherman > > Sent: Tuesday, July 07, 2015 12:45 PM > > To: [log in to unmask] > > Subject: Re: [CODE4LIB] Regex Question > > > > Thanks everyone, this really helps. I'll have to work out the > > italicized stuff, but this gets me much closer. > > > > On Tue, Jul 7, 2015 at 12:43 PM, Kyle Banerjee > > <[log in to unmask]> > > wrote: > > > > > Y'all are doing this the hard way. Word allows regex replacements as > > > well as format based criteria. > > > > > > For this particular use case: > > > > > > 1. Open the find/replace dialog (CTL+H) > > > 2. In the "Find what" box, put (<*>) -- make sure the option for > "Use > > > Wildcards" is selected, and for the format, specify italic > > > 3. For the"Replace box," just put \1 and specify All caps > > > > > > And you're done > > > > > > kyle > > > > > > On Tue, Jul 7, 2015 at 9:32 AM, Thomas Krichel <[log in to unmask]> > > > wrote: > > > > > > > Eric Phetteplace writes > > > > > > > > > You can match a string of all caps letters like "[A-Z]" > > > > > > > > This works if you are limited to English. But in a multilingual > > > > setting, you need to watch out for other uppercases, such as > > > > крихель vs КРИХЕЛЬ. It then depends in the unicode implementation > > > > of your regex application. In Perl, for example, you would use > > > > [[:upper:]]. > > > > > > > > > > > > -- > > > > > > > > Cheers, > > > > > > > > Thomas Krichel http://openlib.org/home/krichel > > > > skype:thomaskrichel > > > > > > > > > >