REGEX - Beginner

[suby]

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

[atcodedog05]

Hi @suby 

So in "(.*)#(.*)", "$2"

(.*) - group before #, group 1

#(.*) - group after #, group 2

$2 keep only group 2.

[suby]

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.

[atcodedog05 · Accepted solution]

Yes thats absolutely right 🙂

[atcodedog05]

Happy to help 🙂 @suby 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂

[suby]

Great thanks much appreciated.