REGEX_Match function to match subset

kavithabanda

Hello!

I'm trying to resolve the following case:

I have to find a match in a list and the example is:

List of words:

------------------

PEPPERCORN

CORN MEAL

CORN OIL

CORN

The pattern match word is "CORN" so my result should return CORN MEAL, CORN OIL, CORN but NOT PEPPERCORN.

I built a sample workflow that uses both REGEX tool and a formula that uses REGEX_Match. REGEX tool returns correct results but I am not sure how to pass a dynamic string there instead of hard coding my pattern.

REGEX_Match does not match CORN MEAL, CORN OIL. It matches CORN with CORN only. How can I make this function work for

CORN MEAL, CORN OIL (but not PEPPERCORN)?

I'm more leaning towards using REGEX_Match solution.

I'm attaching my workflow.

Thanks in advance!

Parse CORN.yxmd

Regex

Preparation

Accepted answers

ddiesel

Hi @kavithabanda

Do you have a list of words that you're trying to match? If so, I think a Find Replace tool will work for you. In the configuration, choose "Any Part of Field" and check the box for "Match Whole Word Only". You can make case sensitive/insensitive depending on your data. Then choose "Append Field(s) to Record:" instead of "Replace". I added "Peanuts" as an example.

See attached and let me know if this works!

Parse CORN ddiesel.yxmd

All comments

ddiesel

Hi @kavithabanda

See attached and let me know if this works!

Parse CORN ddiesel.yxmd

kavithabanda

Thanks ddiesel, looks like this solution might work for me. I have to put this back into my original gigantic workflow to see how it plays there but this is what I was after.

kavithabanda

ddiesel,

This solution works separately but isn't working when I inject into the larger workflow. I am back to looking a solution using REGEX_Match. Any ideas?

Saumil

Hi @ddiesel:

I am trying to do the exact same thing that you did using Find Replace tool. I have a list of words that I am trying to match from a column of text descriptions. The only problem that I am facing is that if the text contains more than one word from the list of words I want to match, it only returns the first one in the match column and not the remaining.

For example: If I have a field with text "CORN PEANUT BUTTER" I want to return CORN and PEANUT both as output in the matched column and not just CORN. Is there a way I could do this ? Thanks in advance.

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703