RegEx Challenge - Character Values in a given word

[Eworabo]

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

[tlarsen7572 · Accepted solution]

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]

Thank you!