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