Skip to Content

Import The Data With Double Quotes Into SAP HANA

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?

Add comment
10|10000 characters needed 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...

  • Get RSS Feed

2 Answers

  • 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\"

    Regards,
    Florian

    Add comment
    10|10000 characters needed characters exceeded

  • Hi Satya,

    I'm facing a similar issue. I wanted to load the data into the HANA table without modifying the TEXT in CSV file. Could you please let me know how you resolved it.

    Regards

    Ganapathi.

    Add comment
    10|10000 characters needed characters exceeded