[
https://issues.apache.org/jira/browse/DRILL-8404?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17693251#comment-17693251
]
James Turton commented on DRILL-8404:
-------------------------------------
Please use the following format configuration.
{code:java}
"type": "text",
"lineDelimiter": "\n",
"fieldDelimiter": "^",
"quote": "\"",
"escape": "\\",
"comment": "#",
"extractHeader": true{code}
> not able read the values properly if column value has double quotes("")
> -----------------------------------------------------------------------
>
> Key: DRILL-8404
> URL: https://issues.apache.org/jira/browse/DRILL-8404
> Project: Apache Drill
> Issue Type: Bug
> Reporter: Ravi Kiran
> Priority: Major
> Attachments: Screenshot_20230224_151019.png,
> WFTABLE-20230224144653.csv
>
>
> Hi Team,
> I am trying to read csv file seperated with Cap(^) symbol and that csv file
> has columns but some of the column value is "Nikita,\"test\"" like this but
> while trying to read this value from drill i am getting "Nikita,\\\"test\\\"
> like this, could you please help on this.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
