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

How to search for specific string with Alteryx

JinOnn
8 - Asteroid

How do I extract the numbers highlighted in red?

 

The numbers are the same except for the last 6 digits.

 

How do I extract that specific number when it appears differently at each row?

 

 

MicrosoftTeams-image.png

2 REPLIES 2
Emil_Kos
17 - Castor
17 - Castor

Hi @JinOnn,

 

Can you try this workflow?

 

Emil_Kos_1-1618829404051.png

 

 

Emil_Kos_0-1618829383083.png

 

It should work for you. 

JinOnn
8 - Asteroid

Thank you so much!

Labels
Top Solution Authors