topic RE: how to Numeric values from String in Product Forum

how to Numeric values from String

Haribp — Thu, 24 Mar 2022 10:21:00 GMT

I Have a string that contains alphabets and numbers and Special characters .How can i get only numbers from string using blueprism?

------------------------------
Hari bp
------------------------------

RE: how to Numeric values from String

PabloSarabia — Thu, 24 Mar 2022 10:46:00 GMT

Hi @Haribp

In this case you can use the typical conversion functions. (ToNumber())

You will need to use some code to achieve this.

With this code, you will get from the string "ab2c3d1" this 231 as a Number

string content = string.Empty;
for (int i=0; i< text.Length; i++)
{
if (Char.IsDigit(text))
{
content += text;
}
}

if (b.Length>0)
{
integer = int.Parse(b);
}
else
{
integer = 0;
}

In this case, "text" is your input value. Your string with alphanumerics and numbers.

And "integer" is your output value. I cast this as a number at the end.

Hope this helps you. And if this solves the problem, remember mark as the best answer 🙂

See you in the community, bye 🙂

------------------------------
Pablo Sarabia
Architect
Altamira Assets Management
Madrid
------------------------------

RE: how to Numeric values from String

PvD_SE — Thu, 24 Mar 2022 12:05:00 GMT

As an alternative to the code stage, Regex could be considered. With a pattern in style with "\d+" or perhaps "[0-9]+" to extract only numerical values from a given text string.

------------------------------
Happy coding!
Paul
Sweden
------------------------------

RE: how to Numeric values from String

NaveenRPA — Thu, 24 Mar 2022 13:56:00 GMT

Hi Hari,

You can extract numbers from a string by using Right, Left, IsNumber Functions natively, without using code stage or Regex.

And

------------------------------
naveen k
------------------------------

RE: how to Numeric values from String

MichealCharron — Fri, 25 Mar 2022 17:55:00 GMT

@Haribp

Adding to @PvD_SE's reply, rather than using the "Regex Extract" action in BP's Utility String VBO, you can use the "Regex Replace" action to replace all non numeric characters with blanks. It is one action that passes out the value to one text data item.

If you can't make it out from the image, the parameters are:

Pattern: "[^0-9]"
Input Data: "The123Rain456In789Spain!@#$."
Replacement Data: ""

The Regex pattern "[^0-9]" uses a negative character group [^] to specify any character not between 0 and 9 (inclusive) in a Unicode codespace.

------------------------------
Micheal Charron
Senior Manager
RBC
America/Toronto
------------------------------