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.
Japanese characters often become garbled when you work with CSV or text files in Microsoft Excel. To avoid the problem, use the Unicode encoding option when saving the data into csv. Unicode is an international standard that includes support for most foreign alphabets. Excel doesn't provide a Unicode option for saving Japanese data to the CSV or delimited text formats, however, so you must first convert the format in utf-8 and then try to open the file from Excel.