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!

Alteryx Designer Desktop Discussions

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

Parsing Data

kaitcoen
5 - Atom

I have a string column (examples of some rows below) where I would like to parse the first 5 characters into a new column. An added bonus would be if I could only parse the first 5 numerical characters because, as you see below, I have some rows that aren't the same setup.

 

Column A

15000 Line 5 Interest

20000 Line 10 Other Income

Case

Line 1 Elims (All Appt)

 

Any tips on parsing are appreciated as it's an area I struggle with!

 

 

 

2 REPLIES 2
JosephSerpis
17 - Castor
17 - Castor

Hi @kaitcoen you can use the Regex tool and parse using (\d{5}) as the syntaxRegex_Example.JPG

kaitcoen
5 - Atom

Thank you, @JosephSerpis! That worked perfectly!

Labels
Top Solution Authors