topic RE: Merge two .dat file after matching first column row in Digital Exchange

Merge two .dat file after matching first column row

kirtish.trivedi — Tue, 10 Aug 2021 10:19:00 GMT

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
------------------------------

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

HarpreetKaur — Mon, 16 Aug 2021 01:35:00 GMT

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
------------------------------

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

kirtish.trivedi — Mon, 16 Aug 2021 04:02:00 GMT

Thank you @HarpreetKaur for suggestion , but I went with the solution mentioned by @AndreyKudinov here
https://community.blueprism.com/communities/community-home/digestviewer/viewthread?MessageKey=419da3f9-e017-4493-9907-cde1472f6c98&CommunityKey=3743dbaa-6766-4a4d-b7ed-9a98b6b1dd01&tab=digestviewer#bm419da3f9-e017-4493-9907-cde1472f6c98

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