In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. 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

extracting seelcted text from a column

griseldagomes
8 - Asteroid


Hello Experts

I am trying to extract text after '\' from the input column upto 8 characters, however unable to do so in alteryx.
Can you please guide me, how can I achieve this?

 

Input
Andy 04/05/2024 6548934665\099265462y test
Brian 06/09/2024 9546849847\404654855z yes

 

Output
09926546
40465485


Thank You

2 REPLIES 2
AGilbert
11 - Bolide

While there are many ways to do this the most succent and powerful is to parse the string with a regex expression. The example below will capture one or more digits (0-9) immediately following a \. The \ itself is a special character so it's normal use must be escaped by another \. 

 

Screenshot 2024-05-11 084508.png

griseldagomes
8 - Asteroid

thank you @AGilbert 

Labels
Top Solution Authors