Blue Prism Product

 View Only
last person joined: 14 hours ago 

This community covers the core Blue Prism RPA product.

  • 1.  Text to Number

    Posted 09-29-2022 17:54
    Hi All,

    Anyone knows how to perform Text to Number conversion in excel using Blueprism?
    Is spying the best approach?

    ------------------------------
    Rishabh Chauhan
    ------------------------------


  • 2.  RE: Text to Number

    Posted 09-29-2022 18:07
    Hi @Rishabh Chauhan,

    Whenever you are dealing with an excel automation, always try for code stage or inbuilt action items rather than going to the spying approach. Code stage is the fastest solution for performing the automation. Did you try code stage in this scenario?​

    ------------------------------
    Ritansh Jatwani
    Manager
    Deloitte
    Gurgaon
    *If you find this post helpful mark it as best answer
    ------------------------------

    Original Message


  • 3.  RE: Text to Number

    Posted 09-29-2022 18:29
    Thanks @Ritansh Jatwani for the response.
    I tried for the code stage but I was not able to succeed in that. Can you please share the code, if you have it?​

    ------------------------------
    Rishabh Chauhan
    ------------------------------

    Original Message


  • 4.  RE: Text to Number

    Posted 09-30-2022 15:26
    Hi Rishabh

    Do you mean you are trying to set the format of a cell from text to a number? or are you trying to get the cell value which is text in excel but you want it to go to a data item in blueprism as a number? 

    If you want to extract it from excel into a blue prism data item then you just need to get the cell value using the Excel VBO and action Get cell value and let it output to a data item which has the datatype number.

    If you want to format the cell value in excel from a text to a number then try using the Excel VBO with either Format cell or Format current cell actions and set the input format to "0"

    Hope this helps :)

    ------------------------------
    Michael ONeil
    Technical Lead developer
    NTTData
    Europe/London
    ------------------------------

    Original Message


  • 5.  RE: Text to Number

    Posted 10-04-2022 22:15
    Hi @Michael ONeil,

    Thanks for your response. I have a huge set of data in an excel which needs conversion from text to number hence I can't use Get Cell Value as it needs to be done for every cell. While I was looking for a solution which can work on a full column. PFB the screenshot for what i was looking for:


    Also, I tried changing the format to '0' but it didn't work.​

    ------------------------------
    Rishabh Chauhan
    ------------------------------

    Original Message


  • 6.  RE: Text to Number
    Best Answer

    Posted 10-03-2022 22:38
    Hi @Rishabh Chauhan,

    You can use the below code for performing the conversion:



    Hope it helps !!​

    ------------------------------
    Ritansh Jatwani
    Manager
    Deloitte
    Gurgaon
    *If you find this post helpful mark it as best answer
    ------------------------------

    Original Message


  • 7.  RE: Text to Number

    Posted 10-04-2022 22:16
    Thanks a ton @Ritansh Jatwani.
    The code worked perfectly fine!!​ :)

    ------------------------------
    Rishabh Chauhan
    ------------------------------

    Original Message


Related Content

Welcome to the Blue Prism RPA Product Community!

Whether you’re looking to manage a complex infrastructure, maintain security and compliance, bring new products to market faster, or gain operational speed and agility in an uncertain economy, Blue Prism delivers — with the flexibility you need to create the business you want. From deployment on-premise, through a cloud service provider or as SaaS, to a skillful and adaptable digital workforce that continually expands to meet your enterprise needs, you can gain enhanced operational insight and control while your people reclaim the time they need to focus on great work.

Product PageKnowledge BaseBlue Prism Training Offering
Product Research ProgramUpdates, Releases & Announcements

FAQs

Blue Prism is intelligent automation — business-developed, no-code automation that pushes the boundaries of robotic process automation (RPA) to deliver value across any business process in a connected enterprise.

A combination of RPA with expanded cognitive and AI capabilities, Blue Prism is different than other automation technology on the market. With one Blue Prism license, you gain instant access to an already AI equipped digital workforce, along with the tools you need to build and delegate automations. Click here for more information on Blue Prism and Intelligent Automation.
To learn more about how Blue Prism RPA can help your organization and how much it will cost to get started, please Contact our Sales department.
Blue Prism RPA can be downloaded from our customer portal. If you would like to consume or download any material it is necessary to create an account on the Portal. Once you have registered, you can access the download options for Blue Prism here.
Yes! Installed on your own machine and supported by our training materials and product documentation, you can use all the features of the full enterprise product for free with our Blue Prism Trial – giving you the opportunity to learn the basics before moving to a full production implementation. Click here for more information and to download the trial.
Yes! You can access our known issue list for Blue Prism from our Support Portal.
Regardless of your industry, Blue Prism’s Digital Workforce can adhere to strict governance and compliance standards without limiting productivity. Click here for more information on how your industry can benefit from Blue Prism.