Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

REGEX PARSE

Anthony_white
7 - Meteor

I am trying to parse out company names to the format shown below (Desired Co_Name). My biggest priority is to remove numbers from the end of a company name if they exist. I am able to clear up the rest in formula tool later in the workflow. However, I am curious to see if everything can be accomplished in a single Regex tool. 

 

Anthony_white_0-1676478302880.png

 

2 REPLIES 2
ShankerV
17 - Castor

Hi @Anthony_white 

 

One way of doing this. Assuming as already you have achieved the remaining output.

Needed to parse the numbers at end.

 

ShankerV_0-1676478830831.png

 

Many thanks

Shanker V

Anthony_white
7 - Meteor

Thanks!

Labels