regex formula for testing

[Chaoued]

I wanted to replace any value except (A1,A2,A3 and A6)

Input : 

A1,A2,R4,E3
A1,A2,A2
B2,C1,A1

Output :

A1,A2
A1,A2,A2
A1

This formula doesn't work

--> REGEX_Replace([field], "\\b(?!A1|A2|A3|A4|A6)\\w+\\b","")

Thanks for your help

[Chaoued · Accepted solution]

This is work for me : REGEX_Replace([field], "A1|A2|A3|A4|A6|,","")

any other solutions ?

[DataNath]

Hey @Chaoued, you can clean REGEX_Replace([field], "A1|A2|A3|A4|A6|,","") up a bit by just using:

REGEX_Replace([field], "A[1-46],","")

[Chaoued]

@DataNath With your formula, it will keep A1 in this exemple B2,C1,A1, and i want to keep Only B2,C1,

[DataNath · Accepted solution]

Ah sorry, pasted the wrong expression! I had this:

Trim(REGEX_Replace([Input], "A[1-46]",""),",")