Find Exact Word in single field containing multiple strings

[connerdy]

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. 

[mutama]

Hi @connerdy ,

Will the attached workflow solution help? At every step, I have annoted in each tool what is intended to do. 

Hope this helps!

Best,

Michael

[DawnDuong · Accepted solution]

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