regex replace help

[Ultralightbeam]

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

[Qiu]

@Ultralightbeam 

So you want the AX to be replace by Microsoft Dynamics AX?

Can you give your desired output?

[Ultralightbeam]

@Qiu 

I have a series of words in a string separated by a comma (,) so now I want AX to be replaced by Microsoft Dynamics AX 

[Qiu]

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

[Ultralightbeam]

@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

[clmc9601]

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".