topic Converting a .CSV file to .DAT in Digital Exchange

Converting a .CSV file to .DAT

BunmiOlufeko — Mon, 16 Aug 2021 08:57:00 GMT

Any ideas on if there is an object on blue prism that can convert an excel file to a data file (from .csv to .dat ) or how to go about this in a blueprism process

------------------------------
Bunmi Olufeko
Head Service Assurance
Union Bank PLC
Nigeria
------------------------------

RE: Converting a .CSV file to .DAT

kirtish.trivedi — Mon, 16 Aug 2021 09:46:00 GMT

Hi,

Not sure about the object but you can use the Move File action of File Management utility to rename from .CSV to .DAT

------------------------------
Kirtish Trivedi
------------------------------

RE: Converting a .CSV file to .DAT

ewilson — Mon, 16 Aug 2021 13:04:00 GMT

The concept of a .DAT file is considered rather generic. In other words, there's no standard related to what a .DAT file contains or what it's structure should look like. The contents and structure are governed by whatever application created/uses the .DAT file. So you need to determine what the target application expects, in terms of the .DAT file, and then you can work on converting the .CSV.

As @Kirtish Trivedi mentioned, it could be as easy as just changing the file extension, or it could involve needing to perform a significant reorganization of the data contained in the .CSV.

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------