Parsing Country codes with RegEx

[pnorby11]

I have a column with 4 digit Country codes bulked together.
Some records have multiple of these separated by comma and in some cases followed by "#".
Where I have: "OTHER USERS" or "DE USERS" or "PT USERS, I want to keep those as is.

Can you please advise what tools and expression would best fit to this scenario?
I am not too good at RegEx unfortuantely.

CURRENT	DESIRED
AL00,#,	AL00
IN50,	IN50
XC01,XC00,#,	XC01 XC00
OTHER USERS	OTHER USERS
DE USERS	DE USERS
PT USERS	PT USERS
RO91,,#	RO91
TR01,TR00,TR02,	TR01 TR00 TR02
TR01,TR00,TR02	TR01 TR00 TR02

[messi007 · Accepted solution]

@pnorby11,

Please see below :

Attached the workflow.

Hope this helps !

Regards,

[binu_acs · Accepted solution]

@pnorby11 @Another way of doing this with the ReplaceChar() function

Trim(ReplaceChar([Field],’,#’, ‘ ‘))

[pnorby11]

Thanks a lot for that!, I tried and it worked perfectly!