How to do Replace using IMPORT Statemet in hana

[former_member597564]

Hello all,

i am using import statement to import data from file server to HANA Tables .

The data is bounded by double quotes in source file.

Is there any way where we can IMPORT with REPLACE double quotes with ' ' in hana ?

Regards,

Nagendra

[abdel_dadouche · Accepted solution]

Hi innovativenaga

Have you tried the following option whichspecifies the optional enclosure character that delimits field data?

OPTIONALLY ENCLOSED BY

Or the following one which specifies the escape character used in the import data.

ESCAPE <escape_character>

Reference: https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.04/en-US/20f712e175191014907393741f...