Handling double quote in external table

Question

Hi ,

Is it possible to ignore double quotes using external file format ? if so what should be the key word i need to use ?

my external table data looks like below.. May i know is there is anyway to ignore these double quotes using external file format ?

Thanks,
Gowri Shankar

Answer 1

Hello @Gowri Shankar ,

You can use String delimiter to ignore the double quotes in the table.

STRING_DELIMITER = string_delimiter - Specifies the field terminator for data of type string in the text-delimited file. The string delimiter is one or more characters in length and is enclosed with single quotes. The default is the empty string ("").

Examples:  
  
STRING_DELIMITER = '"'  
STRING_DELIMITER = '*'  
STRING_DELIMITER = ꞌ,ꞌ  

For more details, refer the below links:

CREATE EXTERNAL FILE FORMAT - STRING_DELIMITER

Use external tables with Synapse SQL - CREATE EXTERNAL FILE FORMAT

You may checkout SO thread which addressing similar issue.

Hope this helps. Do let us know if you any further queries.

------------

• Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.
• Want a reminder to come back and check responses? Here is how to subscribe to a notification.