Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
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
7 - Meteor


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
7 - Meteor

thank you @AGilbert 

Labels
Top Solution Authors