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