Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Announcement | We'll be doing maintenance between 2-3 hours, which may impact your experience. Thanks for your patience as we work on improving the community!
Free Trial

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
Top Solution Authors