RegEx help

[RajatRehria]

Hi team, I need one help, my data has texts like "Notes to accounts ... 1254" , "Notes to many accounts ...... 14552254", "Notes to Cons accounts ..... 4511254". 

I only want the text part using Regex, like Notes to many accounts. Please help. Thanks.

[ShankerV]

Hi @RajatRehria 

One way of doing this.

Input was:

Many thanks

Shanker V

[ShankerV]

Hi @RajatRehria 

Step 1: Input

Step 2: 

Step 3:

Step 4:

([a-zA-Z ]+)

Many thanks

Shanker V

[RajatRehria]

Hi Shanker, didn't find the solution. Can u pls share the workflow or the exact solution

[DavidSkaife]

Hi @RajatRehria 

If you simply want to remove numerical/punctuation then the Data Cleansing tool will work:

[danilang]

Hi @RajatRehria 

@ShankerV gave you a step-by-step to rebuild his workflow.  Just follow the instructions.

Dan