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
Solved! Go to Solution.
Hi @suby
So in "(.*)#(.*)", "$2"
(.*) - group before #, group 1
#(.*) - group after #, group 2
$2 keep only group 2.
So in "(.*)#(.*)", "$2"
Name = 6567;#abc
(.*) - group before #, group 1
On group 1 does it group 6567;
#(.*) - group after #, group 2
On group 2 does it group anything after the #
$2 keep only group 2.
Yes thats absolutely right 🙂
Great thanks much appreciated.