Hi All,
Trying to remove all the characters(number : #) before the string in the name column and email column. Tried using the Data cleansing tool not bringing the desired result.
Any help would be much appreciated
HI @suby
Did you try using the formula tool with the expression,
regex_replace([My field], '.*#', '')
I think this should work. Just need to update the field name for Name and again for Email.
Thanks,
Philip
Yes thats absolutely right 🙂
Hi @suby
Regex Tool | Parse mode
#(.*)
Should do the trick.
If you have multiple fields to work on. You can use mutli-field formula
Formula:
REGEX_Replace([_CurrentField_], "(.*)#(.*)", "$2")
Hope this helps 🙂
Hello,
is that using the Regex tool ?
Thanks this works great but is there a way to combine name and email in one formula.
Sorry can i ask you what exactly the syntax do after the current field.
regex_replace([_CurrentField_], '.*#', '')
