Blue Prism, Calculation, Replace, Extract Number

blueprism rpa
M.p picture M.p · Apr 29, 2018 · Viewed 13.4k times · Source

I need to extract numbers from the a text in calculation stage in Blue Prism. The text is "Please take note of your order reference: 123" The number"123" changes every in each case, every time a new order has been placed. I need to extract the number from the end of this and into a data item. I am currently using:

Right("Please take note of your order reference:","3")and it is not working.

Any advise would be greatly appreciated.

Answer

johwes picture johwes · Jan 24, 2019

I just finished the Developer 1 course for BluePrism and had the same excercise. I used this string:

ToNumber(Replace([Save ordernumber], "Please take note of your order reference:",""))

It removed the text from the string, replacing it with nothing (""), and then creates a number out of the data left in the string. And voilà, you have your ordernumber.

Related questions

nternal : Failed to perform step 1 in Navigate Stage 'XXXX' on page 'XXXX' - Not Connected

I am getting "Not Connected" issue while executing a blue prism object. Currently, I'm working for browser application and I have given browser URL and window title in application modeler. If I launch the application by navigation stage it's working …

Read More
Which RPA tool should I learn being a C# Developer

I am a .NET developer who primarily developed web and stand alone apps using C# since beginning of my career. I am now interested to learn RPA so which RPA tool is best for me to learn where I can …

Read More
RPA-Blueprism - Global Send Keys - Input text which has '(' is not working

RPA-Blueprism - Global Send Keys - Input text which has '(' is not working. Only the text gets entered without brackets, please assist. Ex: 'Paste (Text)' is the text I want to send, however the text is sent …

Read More