Skip to Content

Import The Data With Double Quotes Into SAP HANA

Sep 22, 2017 at 04:21 PM


avatar image

Hi everyone,

I am trying to import a CSV file into SAP HANA using SQL script. Some of the field data in CSV file contains double quotes (Eg: "peter"). After importing the data to SAP HANA it is displaying the particular data without double quotes (Eg: peter). How can I upload the data into SAP HANA including the double quotes?

10 |10000 characters needed characters left characters exceeded

Ok, show your code and the error message/how the wrong data looks and how it should look like, then we can look into your problem.

As of now it looks like you did not even look for answers yourself so far...

* Please Login or Register to Answer, Follow or Comment.

1 Answer

Florian Pfeffer
Sep 25, 2017 at 04:29 AM

You have to escape the double quotes with a backslash that they are considere for the import.

E.g. \"peter\"


10 |10000 characters needed characters left characters exceeded