Find Results for Calculated Field

[derlandson]

I have 2 text fields in a database that I have concatenated into a calculated text field in the same database.  One text field contains a student ID and the other the name of a class.  The calculated text field contains something like "Week 4 Before Care853C410F-42DF-49D6-AD31-BF7A19A2F44A".  I use the calculated text field in a script to determine if a particular student has previously signed up for a particular class.

When my script step enters find mode and sets the calculated text field to "Week 4 Before Care853C410F-42DF-49D6-AD31-BF7A19A2F44A" and then performs the find I get multiple results seen below.  I can't figure out why and for the moment I have set the find within the script to now include "==&Week 4 Before Care853C410F-42DF-49D6-AD31-BF7A19A2F44A".  This has solved the issue, but I still don't quite understand why the initial find of "Week 4 Before Care853C410F-42DF-49D6-AD31-BF7A19A2F44A" produces the 3 results seen below.

Week 3 Before Care853C410F-42DF-49D6-AD31-BF7A19A2F44A

Week 5 Before Care853C410F-42DF-49D6-AD31-BF7A19A2F44A

Week 4 Before Care853C410F-42DF-49D6-AD31-BF7A19A2F44A

 

Thanks for any help/clarification on this

Dan

[comment]

Well, the default find (i.e. with no find operators) looks for "words that start with...". You have entered a search phrase that contains 8 separate words - so the resulting found set will contain all records that satisfy all of these criteria:

• the field contains a word that starts with "Week";
• the field contains a word that starts with "4";
• the field contains a word that starts with "Before";
• the field contains a word that starts with "Care853C410F";
• the field contains a word that starts with "42DF";
• the field contains a word that starts with "49D6";
• the field contains a word that starts with "AD31";
• the field contains a word that starts with "BF7A19A2F44A".

 

[derlandson]

ok, that makes sense, although when I search in the text field that contains the name of the class using "Week 4" I get results that only contain Week 4 and not Week 5.  Is the default find you spoke about only relevant to calculated fields?

[comment]

4 hours ago, derlandson said:

when I search in the text field that contains the name of the class using "Week 4" I get results that only contain Week 4 and not Week 5. 

Why would you expect to find Week 5? It does not contain a word that starts with 4. Searching for Week 4 would find Week 4, Week 40, Weekend 4, 45 Weekly, etc.

4 hours ago, derlandson said:

Is the default find you spoke about only relevant to calculated fields?

No, it applies to text fields and calculation fields with a text result alike (except for fields in Japanese):
https://help.claris.com/en/pro-help/content/finding-text.html

[derlandson]

Thanks.  Did not process the "all of these criteria" issue.  Since I want an exact match then I think I should be good with the use of "==&" before the variable that contains the text I want to find.

Thanks again.

dan