Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

Hi @AlteryxUserFL 

 

Yes, you can use regex parse for this

 

.*(73\d+).*

 

 

Luke_C_0-1628102268512.png

 

Labels