AnsweredAssumed Answered

I need to find records that contain a phrase in one of many fields that also contain another phrase in another set of fields.

Question asked by fapa on Dec 21, 2017
Latest reply on Dec 21, 2017 by beverly

I need to find records that contain a phrase in one of many fields that also contain another phrase in another set of fields.

 

See attached layout. There are two sets of fields in question. 1) RATING fields (1 through 11) and 2) TYPERATING fields (pictured as 1 through 5 but in reality is 1 through 99).

 

I need to run a find like the following.

Find all records that:

Contain "HEL" in ANY of the RATING fields

AND

Contain "LR-JET" in ANY of the TYPERATING fields

 

Note that the phrases are not an exact match but are partial phrases. The "HEL" search could return records with fields containing "A/HEL", "C/HEL", or "P/HEL" and should all be included in the find.

Outcomes