| View previous topic :: View next topic |
| Author |
Message |
johnlill
Newbie
Joined: 31 Oct 2005
Posts: 2
|
 Posted: Mon Oct 31, 2005 2:54 pm Post subject: Newby question about ild cards |
 |
|
One thing I miss that is in Excel is the ability to filter for any record that has a search word in a field. In Excel's standard filter, I would search for FIELDNAME "CONTAINS" SearchWord. I did some searching in this forum and the user guides and it looks like I should be able to do the same thing by FIELDNAME = .*SearchWord.* But that does not work for me. If I change my preferences so that "Search Criteria = and <> must apply to whole cells, I can filter the way I want but I don't want to make that the default. What am I missing?? Thanks.
John L |
|
| Back to top |
|
 |
probe1
Moderator
Joined: 18 Aug 2004
Posts: 2465
Location: Chonburi Thailand Asia
|
| Posted: Mon Oct 31, 2005 4:12 pm Post subject: |
|
|
as a newby:
try the search function.
excel standard filter (search for all terms) hits 15 posts, most with the answer.
_________________
Cheers
Winfried
My Macros
DateTime2 extension: insert date, time or timestamp, formatted to your needs |
|
| Back to top |
|
|
johnlill
Newbie
Joined: 31 Oct 2005
Posts: 2
|
| Posted: Mon Oct 31, 2005 4:59 pm Post subject: |
|
|
| probe1 wrote: | as a newby:
try the search function.
excel standard filter (search for all terms) hits 15 posts, most with the answer. |
Thanks! I did actually search but I was searching on wildcard, wild card, and things like that - which is how I discovered the .*wildcard.*. But 2 of the posts that turned up in your search indicated that I had to tick "Regular Expression" under "more". Not real intuitive to me, but it works now! |
|
| Back to top |
|
|
|
