Jump to content

Find does not find all records


This topic is 7567 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I'm performing a find in a calculation field that combines 3 different fields. If any info is missing from any field, the field will display the word ERROR.

The problem I've encountered is, when I try to find the word ERROR in the field, it will only return the records where ERROR is the last word in the field.

Example:

(record 1 field): 4/C-1/12-ERROR

(record 2 field): 4/C-ERROR-002

will only find the record where the field contained "4/C-1/12-ERROR" and ignore the other record.

I have made a new text field that uses Set Field to copy the values from the calculation field, and did the find in that field, but same results.

I've tried *ERROR and "ERROR" and always get the same results -

I hope I've given enough info, but I am stumped...

Thanks

Link to comment
Share on other sites

You were close with *ERROR. Try *error*. Since the field in the second record has 'error' in the middle, you need wild cards (*) at the beginning and end of your search string.

Link to comment
Share on other sites

This topic is 7567 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.