We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

RegEx Challenge - Character Values in a given word

Eworabo
7 - Meteor

HI, 

 

I would like to extract only the Lb values in a new column. Example: 

 

OXI67FILR-20LB-POLY-FFS-AQUA =  20
YNIRON-SQ-PLIRWND-20LB-FREN-BG = 20

56RON-SQ-PLWND-230LB-FREN-BG = 230

YNIRON-SQ-PLID-20LB-FREN-BG = 20

O456ILR-50lB-POLY-FFS-AQUA =50

OXIROLFILR-5Lb-POLY-FFS-AQUA = 5

 

Thank you, 

 

EW

2 REPLIES 2
tlarsen7572
11 - Bolide
11 - Bolide

You should be able to use this expression in a RegEx Parse tool:

 

\b\d+(?=LB)

 

It identifies numeric characters followed by LB, but it doesn't include LB in the final output.

 

See attached.

Eworabo
7 - Meteor

Thank you! 

Labels
Top Solution Authors