Question

1
Replies
101
Views
Sudha Sundaramoorthy (sunds8)
PEGA
Lead System Architect
Pegasystems Inc.
JP
sunds8 Member since 2020 1 post
PEGA
Posted: November 23, 2020
Last activity: November 23, 2020
Posted: 23 Nov 2020 20:44 EST
Last activity: 23 Nov 2020 23:18 EST

Issue in Opening downloaded CSV file with Japanese characters in Excel

Japanese characters are converted to Junk characters while trying to open csv file, downloaded using Export link of database designer in Excel File.

These database tables are planned to be delegated to users for maintenance. Users requirement is to open CSV in excel directly without having to do additional task of importing data from text/CSV file into Excel by selecting UTF-8 format.

pxExportDataUsingRDPage (of Availability mode Final) is being used to download external database table data to CSV and I am not able to find scope of customizing to add BOM in the downloaded file.

It would be of great help if you throw light on ways to handle this issue.

Pega Platform 8.4.2 Pega Platform Reporting Financial Services