You can translate the question and the replies:

Saving Query results to Excel file

Hi Team, For data validation in Denodo 6.0, I saved query results with delimiter '|' as my data has ',' in some fields. But when i see the data in .csv file generated, comma ',' in fields replaced with space. Ex:- One of my field has value "ABC, Inc". And in saved file, It's showing as "ABC Inc" Please help.
user
19-09-2019 03:21:27 -0400

1 Answer

Hi When I saved the results with the data like "ABC, Inc" with "** | **" as the separator, I was able to retrieve the results with "," in it by opening the saved file in a tool like Notepad. But I was able to reproduce your behavior when opening in Excel file and it was fixed by the following steps, * Open the saved file in a Notepad. * Enter the below text in the first line, ` SEP=|` * Save the changes and open the saved file in Excel. Hope this helps!
Denodo Team
20-09-2019 09:25:52 -0400
You must sign in to add an answer. If you do not have an account, you can register here