Blue Prism Product

 View Only
last person joined: 9 hours ago 

This community covers the core Blue Prism RPA product.

  • 1.  CSV text as collection giving special character in header

    Posted 08-10-2023 18:57

    I am reading a CSV as CSV text as collection action. i am getting special chacacter in first rows.

    on checking found, encoding of CSV is UTF-8 BOM . how to fix this in blue prism so that it do not give special character.



    ------------------------------
    Neeraj Kumar
    ------------------------------


  • 2.  RE: CSV text as collection giving special character in header

    Posted 08-11-2023 04:25

    Hi Neeraj,

    I'd like to provide you with some suggestions on how to handle a UTF-8 BOM encoded CSV file:

    • Read the CSV data using MS Excel-VBO (Get worksheet as Collection Action)
    • Remove the UTF-8 encoding using custom code stages.

    Between these alternatives, opting for the MS EXCEL - VBO approach appears to be the more straightforward solution.



    ------------------------------
    Athiban Mahamathi - https://www.linkedin.com/in/athiban-mahamathi-544a008b/
    Technical Consultant,
    SimplifyNext,
    Singapore
    ------------------------------

    Original Message


  • 3.  RE: CSV text as collection giving special character in header

    Posted 08-11-2023 07:03

    Hi Neeraj,

    If you can attach a sample csv file, then I can help you with custom codes for the same.

    Also Neeraj in the meanwhile try to use the Import CSV function present in BP Default. You may have to change the code a bit according to your requirement then it will work. Just record a macro while importing the csv into Excel. You will get the below-attached code copy the same here. It should work. The highlighted one is the code for UTF -8 that you have to change in the existing code.

     

    To get this option in Excel 365 you have to do few changes to get the above code by recording macro. Please see attached image for this,



    ------------------------------
    Amlan Sahoo
    Senior RPA Consultant
    WonderBotz
    ------------------------------

    Original Message


  • 4.  RE: CSV text as collection giving special character in header

    Posted 08-11-2023 07:35

    hello Amlan Sahoo & Athiban Mahamathi Mathialagan

    actually want to avoid using EXCEL VBO route and macro. but that is good suggestion -will try out this option.

    i found one utility on digital exchange. that one is working fine.

    https://digitalexchange.blueprism.com/dx/entry/3439/solution/blue-prism---read-csv?_ga=2.164614207.1278002800.1691419152-1643662959.1690267307&_gl=1*xu4g8w*_ga*MTY0MzY2Mjk1OS4xNjkwMjY3MzA3*_ga_MFBQ2KFZ1L*MTY5MTY3NDg3NS4xMi4xLjE2OTE2NzcxMjYuMzkuMC4w



    ------------------------------
    Neeraj Kumar
    ------------------------------

    Original Message


  • 5.  RE: CSV text as collection giving special character in header

    Posted 08-11-2023 17:12

    @Neeraj Kumar,

    If you are getting the same special character consistently, then I would suggest the following:

    • Read your CSV file into a text variable.
    • Clean up your header in the text variable
      • I would use the Replace function
      • If the character is not consistent, then maybe a RegEx evaluation would be in order
    • Using the same Strings object, use the 'Delimited Text to Collection' function on your clean(-er) text value

    I know that I have also seen some of the actions have an input field for the formatting (UTF-8, UTF-8 BOM, etc), so it might be worth asking to have this added to the Strings object.

    Good luck,

    Red



    ------------------------------
    Robert "Red" Stephens
    Application Developer, RPA
    Sutter Health
    Sacramento, CA
    ------------------------------

    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.