Find challanges

[yossi]

Hi

I have a table of words and I want to perform a find in order to get all the words consisted of certain letters and only them.

For example:

The words in the table are: door, red, deer, dream, men

Each word in a field called: Word

I want to find all the words consisted of the letters: d, e, r and only these letters.

The result of the Find should be the words: red, deer (and only these words)

I tried two approaches:

A. Performing a find with the following requests:

Word: *d*

And

Word: *e*

And

Word: *r*

The problem here is that it is not possible to perform an ‘And’ request on the same field.

B. Putting each letter of a word in a field of its own called L1, L2…

For example for the record of the word ‘red’ L1=r, L2=e, L3=d

Then perform a Find with the following requests in the following order:

L1: *d* OR L1: *e* OR L1: *r*

And

L2: *d* OR L2: *e* OR L2: *r*

Etc.

The problem here is that I don’t know how to perform a set of OR requests with ‘And’ between them (as shown above) or even if it’s possible.

Any suggestions?

Thanks!!

Yossi

[imoree]

Enter FInd mode; Put in Door

then from requests in menu enter new request and type in new word.

-i

[yossi]

Thank you for your reply but I’m not sure I understand, can you please elaborate on logic behind such a Find?

Every new request is an OR, isn’t it?

Another thing is that my table has more than 3000 words (for now…)

Maybe my explanation isn’t clear, the idea is to find the words consisted of certain letters automatically (eventually with a script)

[imoree]

Find.fp7.zip

perhaps this is a start..

[efen]

Something like the attached? No error trapping or allowance for blank fields

letters.zip

[Lee Smith]

Automatic message

This topic has been moved from "FileMaker Product Family → FileMaker Pro 11" to "Database Schema & Business Logic → Finding & Searching".

The General topic areas are intended for the discussion of the functions, features and tools that were new with the particular version you posted in.

All how-to question should be posted to a topic area that best matches the sprit of the problem. Many questions can fit into more then one area, but you only need to pick one, and go with it.

If you have any questions about this action, please contact me through a private message.

Lee

[yossi]

wow! this exactly what I need!

thanks!!

Yossi

[LaRetta]

Something like the attached?

Enter Find Mode [ ]

Perform Find [ Restore ] ?

Why the Enter Find Mode [ ] first, Efen? It isn't needed with a Perform Find[]. I think you realize this so I just want to clarify. Sometimes we assist when in a hurry and little things such as this can slip through. I thought I should mention it only because newer folks might think it's necessary when it isn't.

Nice solution though. :^)

[efen]

in a hurry and little things such as this can slip through

exactly - my error, didn't notice

thanks for the compliment