RegEx help

Question

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.

danilang · Answer

Hi @RajatRehria

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

Dan

davidskaife · Answer

Hi @RajatRehria

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

Data Cleansing.yxmd

RajatRehria · Answer

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