Alteryx Designer Desktop Discussions

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

Extract text from Cell

lipster26
7 - Meteor

Hello,

 

There is a column that has a mix of numbers and "-" and text. I'd like to extract the text at the end of the string into its own column. What is the best way to do that? Attached is the file with the data. Thanks

 

lipster26_0-1656340901303.png

 

3 REPLIES 3
DataNath
17 - Castor

How does this look @lipster26? Workbook attached:

 

 

(?:[0-9-]+)-([a-z\s'-]+)

 

 

Extract text from end of line.gif

 

EDIT: Simplified the RegEx

 

(?:[0-9-]+)-([\D]+)
lipster26
7 - Meteor

That works perfect. Thanks!

messi007
15 - Aurora
15 - Aurora

@lipster26,

 

Please see below :

 

messi007_0-1656341718273.png

 

Attached the workflow,

Regards,

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels