Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Community is experiencing an influx of spam. As we work toward a solution, please use the 'Notify Moderator' option on the ellipsis menu to flag inappropriate posts.

Alteryx Designer Desktop Discussions

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

Extracting A Set of Numbers from a String

AlteryxUserFL
11 - Bolide

I need to extract a number form a long string with text and numbers. Basically, I need to extract the first number that starts with 73. Would Regex be best? Please see below for an example. 

 

Start:

" 19071017 TOTAL BUDGE OLD PO 739003018  40373,PROTOCOL NO 3222220140106 CO5 THIS PROPOS 06 CO6 THIS AMENDMENT IS SUBJECT TO THE AND CONDITIONS OF THE MASTER AGREEMENT CONTRACT NO XYZ220 ENTERED INTO BY AN."

 

Output: "739003018"

1 REPLY 1
Luke_C
17 - Castor
17 - Castor

Hi @AlteryxUserFL 

 

Yes, you can use regex parse for this

 

.*(73\d+).*

 

 

Luke_C_0-1628102268512.png

 

Labels