Hi guys,
I have a mile-long list of entries and I want to find all entries that end in "whatever" or "whatever 2".
For example:
spiderman
batman
auqaman
flash
captainamerica
superman
batgirl
supergirl
hulk
I want to find all the entries that end in "man" OR that end in "girl".
Any idea how this is done? I honestly searched the forum and the Calc
help files but couldn't find something.
Thanks in advance for your help,
CalcNoob
[Solved] Find cells that end in "whatever" or "whatever 2"
[Solved] Find cells that end in "whatever" or "whatever 2"
Last edited by Hagar Delest on Tue Jun 10, 2008 2:21 pm, edited 2 times in total.
Reason: tagged the thread as Solved.
Reason: tagged the thread as Solved.
Re: Find cells that end in "whatever" or "whatever 2"
You can search/find them using Edit > Find & Replace.
Search for: (man|girl)$
Options > Regular expressions: YES
Click "Find All"
However, there is precious little you can do with them once you find them.
Calc can't do anything with multiple selections; you can't even copy them to the clipboard, so I'm not sure it's going to be much use to do it this way.
You can always use "Find" one at a time, but that's pretty tedious.
Search for: (man|girl)$
Options > Regular expressions: YES
Click "Find All"
However, there is precious little you can do with them once you find them.
Calc can't do anything with multiple selections; you can't even copy them to the clipboard, so I'm not sure it's going to be much use to do it this way.
You can always use "Find" one at a time, but that's pretty tedious.
AOO4/LO5 • Linux • Fedora 23
Re: Find cells that end in "whatever" or "whatever 2"
I suspect CalcNoob actually wants to filter, in which case your expression works, so long as Tools > Options... > Calc > Calculate > Search criteria = and <> must apply to whole cells is OFF.
will work regardless of that setting, again so long as Regular expression is turned ON in the filter More Options.
Code: Select all
.*(man|girl)$
Re: Find cells that end in "whatever" or "whatever 2"
Excellent points--thanks huw!
I always forget about using a filter.
I always forget about using a filter.
AOO4/LO5 • Linux • Fedora 23
Re: Find cells that end in "whatever" or "whatever 2" [RESOLVED]
Thanks for your replies.
.*(man|girl)$ was *exactly* what I was looking for.
I really appreciate this.
CalcNoob.
.*(man|girl)$ was *exactly* what I was looking for.
I really appreciate this.
CalcNoob.