Skip to Content
avatar image
Former Member

HANA Studio: Export Catalog object with non-standard delimiter

I want to export a table via HANA Studio. The table has a text column which contains commas (,) in the text. As the default delimiter for the CSV export is also comma (,) the import fails as it won't map the columns correctly.

Is there a way to use another delimiter e.g. semicolon (;) for the export? I also found documentation for a SQL console EXPORT command, but it also seems not to provide parameters for setting another delimiter character (https://help.sap.com/viewer/6b94445c94ae495c83a19646e7c3fd56/2.0.00/en-US/1f20a6c4364c4b0680596e74e4ba281d.html). I'm using a HANA Express VM.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers