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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.