Hi,
tried already several ideas but my knowledge with Regex_Replace is limited.
I have a dataset with various columns. The "Name" column includes e.g. the full name of a bank (e.g. Branch of the Bank of Russia). I want to remove all this 2 character words (in this case "of"). Additionally, my data consists of a lot of cyrillic entries which makes it even more complicated. I don't know how to created the Regex_Replace formula or is there an other way for this problem?
Thanks in advance
Solved! Go to Solution.
@taxhead ,
REGEX_Replace([Field1], "\b\w\w\b", '')
This formula will do it all for you.
Replace what is a word boundary followed by 2 word [A-Za-z0-9_] characters followed by a word boundary with nothing.
If you want any character use "\b..\b" it will include non-latin.
BTW:
[^\u0000-\u007F]+
That is all non-Latin characters.
Cheers,
Mark
Thanks, this worked very well!