Bug 7486

SaveAs csv separator problem 22 November, 2021

Markus Schröder
10 November, 2021
Product: PowerBuilder Category: DataWindow
Version: 2021 Build: 1288
Classification: Unsupported Publishing: Public
Priority: P3
Status: Closed Reason: RESOLVED
Mark Lee @Appeon 22 November, 2021
#8
Hello Samuel,

Thanks for your feedback.
We will proceed to close this ticket now.
 
BTW, as we said before, we think this is a PB normal behavior. 
If the problematic number must be surrounded by quotes or some other separator, this can lead to data type conflicts since only the string data type has the quotes identifier.

Regards,
Mark Lee
Markus Schröder 22 November, 2021
#7
Hello Mark,
the problem is not solved, because it is not possible to export a data window with decimal numbers correctly to a csv file.
I think that the problematic number must be surrounded by quotes or some other separator must be used by PowerBuilder.

When I do a csv export in MS Excel, I get the following csv output for the 3 values 1,3 and 1.3 and 1;3 (german setting)
1,3;1.3; "1;3"
Our customer has since switched to an export in Excel format, so the incident can be closed.
Mark Lee @Appeon 21 November, 2021
#6
Hello Samuel,

I would like to check with you if the response provided has been helpful enough to resolve your case. If so, can we proceed to close the ticket?. Otherwise, please let us know if we can provide you with any further assistance, remember that you can always open another ticket any time you need it. 

Regards,
Mark Lee
Mark Lee @Appeon 15 November, 2021
#5
Hello Samuel,

Thanks for your feedback.
For this comma-delimited(.csv) format conflict problem, it is related to the Windows Operating System having the German language setting (decimal point is comma). It has nothing to do with the PB product itself, so we suggest you look for a solution elsewhere.
 
Currently, there are the following three workarounds:
1. Modify the setting value of German language decimal symbol to non-comma
2. Use another format such Excel file to save the file
3. As you said, "paste the same numbers into Excel (with a comma) and save as a CSV file."
 
I am afraid that we don't have other better solutions. And since this issue is not a bug or failure but an unsupported feature, we will proceed to close this ticket. If there's any other problem, please open a new ticket. Thanks for your understanding.

Regards,
Mark Lee
Markus Schröder 11 November, 2021
#4
Hello Mark,

unfortunately our customer needs a csv file. 
When I paste the same numbers into Excel (with a comma) and save as a csv file, Excel correctly quotes the values.
Mark Lee @Appeon 11 November, 2021
#3
test result

Hi Samuel,

Thanks for reporting this problem.
I can reproduce it on our side. But this behavior is the same across all PB versions, which is normal.
Even if I exported a normal csv file in the English region, after switching the region to German, the format of the csv file is incorrect (refer to the attachment) after opening the csv file.
 
For this comma-delimited(.csv) format conflict problem, it is recommended to save it in an Excel file format instead of the comma-delimited(.csv) format.

Regards,
Mark Lee
Chris Pollach @Appeon 10 November, 2021
#2
Hi Samuel;

  Thank you for the Test Case PB App and instructions on how to recreate this issue! We will need some time to recreate the problem on our side.

  I will now transfer this ticket over to the main Support / Engineering team for their review & feedback on this problem.

Regards ... Chris
Markus Schröder 10 November, 2021
#1
test.zip (9KB)

*Phenomenon: when i save a datawindow as a csv file then decimal numbers are not double quoted correctly. My windows operating system has the german language setting (decimal point is comma). The seperator is also a comma, so the resulting csv format is not correct.

*Reproduce Steps: click on the button in the demo app and create a csv file.
Before that, set the region german (germany) in the windows system settings.

Remarks:
OS:
Windows 10
Platform:
64-bit
Database Type:
Oracle
Database Version: