Extract Number from string

Patnaik14

Member
Hi All,

How to extract a number from a text string in blue prism ?
Ex: Purchase Order: 123456 AXIKIYRT
Expected Result: 123456

The length of the number also vary some time, but the pattern remains same.

Thank you
 

Sukesh Kumaru

Active Member
Hello,

You can make use of IsNumber() function available in calc stage and check with each letter in that string.
If it is a number, it returns True then copy that letter to another dataitem, continue this for end of the string.

Good Luck.
 

ShubhamJangam

New Member
Hi,

If you are using Utility - Strings::Extract Regex Values without giving "Named Values" Collection (Input ) then use this
(?<Lower>\d+)

Thanks
 
Top