Find . . . Using Boolean, Dates, and Wildcards

[slack7639]

I found out how to do this in Win 10 File Explorer:

Learning Windows Search: Use Boolean, Dates, and Wildcards to Give Your Searches a Boost . . . https://www.howtogeek.com/school/learning-windows-search/lesson4/

I don't see that that syntax works in Excel 2010's "Find"

Do you have to use a macro to do it? Is there one I can copy and paste somewhere? Thanks!!!

 

[slack7639]

I figured out an easy way to get all occurrences of a word or phrase - but I found some bug:

Use concatenate on 18 fields:

=CONCATENATE(CONCATENATE(TEXT(A2,"000000.000"),".",B2,".",C2,".",D2,".",E2,".",F2,".",G2,".",H2,".",I2,".",J2,".",K2,".",L2,"."),M2,".",N2,".",O2,".",P2,".",Q2,".",R2,".",T2,".",V2)

Then, use the Advanced Filter function to search that column - all words will be contained in it (21,000 records).

How to Use Advanced Filters in Excel - YouTube . . . https://youtu.be/C_2cjh5Pd8o

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

$A$10:$AD$21541
$A$1:$AD$2

You can't really backspace to clear what's there. Just click the square at right, select the range - tab to criteria, and press enter.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

You have to put an asterisk before and after the word(s) you want, because it's searching a column with the CONCATENATION of many words.

The search is not case sensitive

Wild-cards work with the asterisk, but it's sensitive to word order . . . *alternative* *reactor* . . . works, but not . . . *reactor* *alternative*

a.) Is there a way to make it so it's not "word order sensitive"

b.) Is there a way to use IF / AND / OR ? It didn't work

This is useful for finding all occurrences of one word, or a phrase that you can remember

Current question: Why doesn't it see the word "pebble" in the concatenate of the last one of these four? It only comes up in the query if I put that word in the Title

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

700000.000.Nuclear.Design.Type K.Alternative.Pebble Bed Reactor.............Pebble bed reactor - Wikipedia.40628
700000.000.Nuclear.Design.Type K.Alternative.Pebble Bed Reactor.............THE PEBBLE BED MODULAR REACTOR (PBMR) - NIRS.41424
700000.000.Nuclear.Design.Type K.Alternative.Pebble Bed Reactor..Fail...........What's Wrong With the Modular Pebble Bed Reactor?.41424
700000.000.Nuclear.Design.Type K.Alternative.Pebble Bed Reactor.............How to make a nuclear reactor that can't have a meltdown.40628

*pebble* . . . gets all 4
*design* *pebble* . . . gets all 4
*pebble* *4* . . . gets all 4
*pebble* *bed* . . . gets all 4
*700000* *pebble* . . . gets all 4
*nuclear* *pebble* . . . gets all 4

*type k* *pebble* . . . only gets the first 3 . . . Could the space have anything to do with it? No, I tried it with no space, and it still did not work.
*Type K* *pebble* . . . only gets the first 3
*alternative* *pebble* . . . only gets the first 3

*type k* *meltdown* . . . only gets the last one

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

"Pebble" is not in the Title of the last one. What if I add that, at the end?

700000.000.Nuclear.Design.Type K.Alternative.Pebble Bed Reactor.............Pebble bed reactor - Wikipedia.40628
700000.000.Nuclear.Design.Type K.Alternative.Pebble Bed Reactor.............THE PEBBLE BED MODULAR REACTOR (PBMR) - NIRS.41424
700000.000.Nuclear.Design.Type K.Alternative.Pebble Bed Reactor..Fail...........What's Wrong With the Modular Pebble Bed Reactor?.41424
700000.000.Nuclear.Design.Type K.Alternative.Pebble Bed Reactor.............How to make a nuclear reactor that can't have a meltdown - PEBBLE.40628

*type k* *pebble* . . . gets all 4
*Type K* *pebble* . . . gets all 4
*alternative* *pebble* . . . gets all 4

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

 

[slack7639]

Figured part of it out:

*type k* *pebble* . . . Why doesn't this bring up one of the records?

. . . It's looking for a space in between the two words, not individual words with asterisks around them

. . . Leave that out, and, only use one asterisk in between the words - it's applied to the next word

Use . . . *type k*pebble*

 

[slack7639]

Ok, now I can do most of what I want, which is "good enough""

To specify an implicit AND or OR operator, place expressions on the same, or separate, rows, respectively . . . https://www.techrepublic.com/blog/m...and-or-operators-with-excels-advanced-filter/