regex replace help

Question

Hello I have an array of strings example is (AX,AXAPTA, Microsoft Dynamics AX), using regex replace i'm not sure of what syntax to use where if this specific AX is in a string it will be classified as Microsoft Dynamics AX

clmc9601 · Answer

Hi @Ultralightbeam,

After the "expected output" shown above, you could try placing a formula tool with this formula:

IF Regex_CountMatches([System], "(?:^|[^\w])AX")>0

THEN "Microsoft Dynamics AX"

ELSE [System or Field2]

ENDIF

It looks for either the start of a string or any non-letter character before "AX".

Ultralightbeam · Answer

@Qiu I think my question was wrong

So I have an input see image below, where as System contains multiple words delimited by comma, for every system I want it to be classified to something else using a conditional statement and further will be text to rows (see second image for output) note that duplicated on the input will only count as 1 row.

- I think it shouldn't be compared as contains (AX is also contains in PortAX while it's different)

Expected Output

Qiu · Answer

@Ultralightbeam 
I assume you dont want "Microsoft Dynamics AX" to be replaced.

New Workflow2.yxmd