cancel
Showing results for 
Search instead for 
Did you mean: 

SAC Application design csv export api set semicolon as delimiter instead of comma

PeterSigi
Explorer
320

Hi community
I am implementing a SAC Application Design App and there should be a button to export table data as csv but delimited by semicolon and not by comma. If I am doing the export by right click on the table there is a field in the dialogue to change the separator to semicolon. But this is not available if doing the export via scipt api.
Any ideas out there how to achive this in Export Api?

Every hint is much appreciated.

Best

Peter

venkateswaran_k
Active Contributor
0 Kudos

Hi Peter

It is recommended to use ; only. Because for amount fields the thousand separators are ,

To avoid ambiguity - semi colon is a right one.

Regards,

Venkat

PeterSigi
Explorer
0 Kudos

Hi Venkat

Many thanks for your feedback.

But the problem is that comma is the standard delimiter and i cannot change it within the export api.

Best

Peter

venkateswaran_k
Active Contributor
0 Kudos

Hmm, okay

Please check this blog. If useful to you.

Hope comma should work as per this blog.

https://blogs.sap.com/2021/11/18/best-practices-for-sap-analytics-cloud-csv-and-excel-export-perform...

Accepted Solutions (0)

Answers (1)

Answers (1)

yousrataghouti
Discoverer

Hello peter_siglreitmeier83! Did you find a solution ? I have the same issue!