Skip to Content
0

HANA Studio: Export Catalog object with non-standard delimiter

Mar 30, 2017 at 01:25 PM

69

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers