Regex remove some characters from string

Hi @jorgemartcaam , no problem. I think the confusion was “The column objective would be “Emoji Free””, so I thought you were trying to figure out how to get to the values in the Emoji Free column.

Nevertheless, I understand what you want now.

“since I will never figure out how regex works”. It’s kind of the same for me. I usually go look for the Regex Expression online :sweat_smile:

However, this time, I wrote the Regex Expression on my own! I’m reading this document if you are interested:
https://dl.icewarp.com/online_help/203030104.htm

So, based on the list in your first post, I came up with this:
regexReplace($Emoji Free$, "^PB_Coordi_|^PB |^BS |^ZH-ES_|^Coordi ", "")

It’s saying find whatever starts with “PB_Coordi_” or with "PB " or with "BS ", etc… and replace those matches with “”

Results:

Here’s the workflow:
Remove some characters at the beginning of string.knwf (17.1 KB)

4 Likes