Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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