Find Exact Word in single field containing multiple strings

Question

I'm running into an issue where CONTAINS([EXCL_HCC_ID], [Row-1:HCC]) is returning true because the individual characters of EXCL_HCC_ID can be found in the HCC field. See the below screenshot for reference.

Is there a way to search for the complete 159 value in a list of strings instead of matching on the characters.

DawnDuong · Accepted Answer

Hi @connerdy

If you want to find the Exact match, you can use the string function

FindString(String,Target): Searches for the occurrence of a particular string (Target) within another string (String) and returns the numeric position of its occurrence in the string.

Returns the 0-based index of the first occurrence of (Target) in (String). Returns -1 if no occurrence.

dawn