Digital Exchange

 View Only
last person joined: 5 days ago 

This community is a place to discuss Blue Prism DX assets and development.

  • 1.  Merge two .dat file after matching first column row

    Posted 08-10-2021 11:19
    Hi Community,

    I am trying to  merge two .dat files after comparing that the  first row has the same columns. Syntax for the .dat file is as below(when I open with notepad)

    Project ID  Employee ID      Project Type
    XXXX         xxxxxxxxxxx       xx

    1 ) First I need to check if the column matches in both files
    2) After that I need to append the content of second file to first file after removing the header

    I thought of renaming .dat with .csv file,Append the records,save and rename back to .dat. but there were two problems :- 

    1 ) Headers are in japanese. When i change extension to .csv , japanese characters are getting replaced with some other weird character.
    2) When I append data to csv and rename back to .dat, " is added before the line and after the line as below

    "Project ID  Employee ID      Project Type"
    "XXXX         xxxxxxxxxxx       xx"

    Could someone please suggest how to proceed ? 

    Kirtish Trivedi

  • 2.  RE: Merge two .dat file after matching first column row

    Posted 08-16-2021 02:35
    Hello Kritish,

    Can I suggest that when you try to save your .dat file as a csv, you change the Encoding default option and select "UTF-8 with BOM" instead and then try?

    Harpreet Kaur Product Consultant

  • 3.  RE: Merge two .dat file after matching first column row

    Posted 08-16-2021 05:02
    Thank you @Harpreet Kaur for suggestion , but I went with the solution mentioned by @Andrey Kudinov here​

    Kirtish Trivedi

Welcome to the Blue Prism Digital Exchange Community!

The Blue Prism Digital Exchange is a "shop window" for new and emerging technologies—a platform that puts powerful RPA and AI capabilities into the hands of business leaders. Users can find and apply pre-built AI capabilities, in the form of downloadable integrations and Visual Business Objects (VBOs), to automated processes. These assets connect and integrate Digital Workers, existing systems and processes to Blue Prism's technology partners, creating a solid foundation of AI-enabled Intelligent Automation that's scalable and sustainable.

Blue Prism Digital ExchangeDX Asset IdeasContact DX Support


The Blue Prism Digital Exchange (DX) is an online marketplace where businesses can instantly access, apply and share pre-built AI, cognitive and advanced RPA technologies from best-in-class providers. These assets easily connect to existing digital workers, systems and processes to enhance automation capabilities.
The Digital Exchange is free to all users. Most of the content on the DX is free to download but there are some submissions that do have a cost associated. The submissions with a cost are advertised on the asset card and profile. No unwanted costs will be applied to any users.
You can visit and browse the Digital Exchange here. If you would like to consume or download any material it is necessary to create an account on the Blue Prism Portal first.
Everyone can access the Digital Exchange and consume the assets on it. If you would like to contribute to the marketplace it is necessary that you create an account and sign up as a partner.