how to find an exact match in a string

Hi,

I am looking for a string function to find an exact match in a string.

For example, a field with values, "ABC222","ABC", "ABC123". if I use findstring() or contain() function to find a value of "ABC", it will return the 3 values, but I only want to return a record with a value "ABC", not all 3.

Thanks

Help

Accepted answers

Kenda

@khap I would recommend changing your expression to this:

iif([FieldName]="ABC",1,0)

This will fill in a 1 if the field is equal to "ABC" and a 0 otherwise.

All comments

Kenda

Hey @khap! Would it work for your purposes to add a Filter that just says [FieldName]="ABC" ?

khap

I have to use If statement to check condition. If (findstring(fieldname ="ABC") = 0) then "1", but it returns all. looking for an exact match.

Dewey

You could also use REGEX_match(string,pattern) for this.

REGEX_match([FIELDNAME],"ABC")

isaactong

Hi all,

I have similar problem that I need to search a string in one field with an exact match of the string in another data field, however, there are many possible strings and I don't know all possible matchings. For example, find exact match of "AB" in another field ("AB", "AB1", "CD", "CD1", "EF", "EF1"), but may be "CD" or "EF" that I cannot find out all possible match strings, any command can return positive or negative of matching? thank you for your advice in advance.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703