search

dinedal / textql

Execute SQL against structured text like CSV or TSV
MIT License
9.05k stars 300 forks source link

escape characters #91

Open J-S-Flynn opened 6 years ago

J-S-Flynn commented 6 years ago

there seems to be no way of adding an escape character to a string. simply putting the \ in the string breaks it.

dinedal commented 6 years ago

Could you provide an example?

NankaBananka commented 5 years ago

@dinedal query like this doesn't work and results with syntax error

textql -header -output-header -sql "
select distinct question
where question = 'what didn't you find?'
" events_event_id_attendees_answers

tried escape ' like this: \', '', "'"