Start Free Trial

Alteryx Designer Desktop Discussions

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

How to extract number following a certain pattern

summer0805
6 - Meteoroid

Hi,

 

I need to extract pack number from the title of products. For example, I need to extract 25 from the title below: 

 

12mm I.D. x 16mm O.D. x 0.25mm Shoulder Screw Lengthening Shim (Pack of 25) - Made In USA

 

Please help! I have attached a copy of sample data. Thanks! 

3 REPLIES 3
bbak91
Alteryx
Alteryx

Maybe something like this? Workflow attached. 

 

parsing pic.png

summer0805
6 - Meteoroid

It works! Thank you so much! 

bbak91
Alteryx
Alteryx
Also just realized that you could consolidate this into one regex tool: Pack\sof\s(\d*)
Labels
Top Solution Authors