ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

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
Top Solution Authors