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 |
Solved! Go to Solution.
@pnorby11 @Another way of doing this with the ReplaceChar() function
Trim(ReplaceChar([Field],’,#’, ‘ ‘))
Thanks a lot for that!, I tried and it worked perfectly!