Hot to find a specific acronym in a text field

hellyars

I want to find the acronym EW in a description field. It is only 2-letters and always in ALL CAPS.

I tried the the Contains([Description], "EW"). This seems to pickup anything that contains "ew" in a word.

What might be a more direct way of zeroing in on this and other acronyms?

Thanks

Help

Preparation

Expression

Accepted answers

CharlieS

There's an optional third argument for the Contains function that will specify if you want the matching to be case sensitive. Try this formula:

Contains([Description],"EW",0)

BenMoss

Personally I would use the 'find and replace' tool to perform this task in append mode which you can then add a flag field too.

By default the find and replace tool is case sensitive though you can change that.

You would configure it to search 'any part of field'.

The benefit of the find and replace tool is you can easily extend this list to search for other values too.

Example attached.

Ben

Example.yxmd

All comments

neilgallen

@hellyars you can use regex and place your pattern in a word boundary (\b pattern \b).

CharlieS

There's an optional third argument for the Contains function that will specify if you want the matching to be case sensitive. Try this formula:

Contains([Description],"EW",0)

BenMoss

Personally I would use the 'find and replace' tool to perform this task in append mode which you can then add a flag field too.

By default the find and replace tool is case sensitive though you can change that.

You would configure it to search 'any part of field'.

The benefit of the find and replace tool is you can easily extend this list to search for other values too.

Example attached.

Ben

Example.yxmd

hellyars

@CharlieS that works. @BenMoss you read my mind. There are other search terms I will need to flag in the text field. Your Find Replace approach works perfectly, especially the ability to add to the list and customize the "flag" output.

Thank you.

hellyars

@BenMoss.

Here is a twist. I expanded my keywords to include both EW and IA. How do use the Find Replace approach to account for records that might contain both keywords?

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703