In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Extracting data from the text

SH_94
11 - Bolide

Hi Community,

 

I would like to ask how do we extract the data below so that it will presnt the output as below. I would like to use the regex formula to do the extraction.

 

SH_94_0-1680769763146.png

Many thanks

3 REPLIES 3
DataNath
17 - Castor
17 - Castor

Hey @SH_94, a couple of questions here. Is there any reason it needs to be regex? Is this a consistent format? My initial thought is that you could just handle it with something simple like so if the format allows:

 

DataNath_0-1680770113122.png

 

GetWord([Input], 1)

 

Regex-wise, there's a bunch of different options but ultimately I'm assuming you're basing the position based on Valuation again, so something like this could work:

 

DataNath_1-1680770199171.png

 

Valuation\s([^\s]+)
ShankerV
17 - Castor

Hi @SH_94 

 

One way of doing this with formula as requested is below.

 

ShankerV_0-1680773093341.png

 

ShankerV_1-1680773104349.png

 

 

Many thanks

Shanker V

ShankerV
17 - Castor

Hi @SH_94 

 

You can use other than formula also like Text to columns and Regex tool.

 

ShankerV_0-1680773248096.png

 

ShankerV_1-1680773326933.png

 

Many thanks

Shanker V

Labels
Top Solution Authors