Azure Data Studio set tab as delimiter when exporting a csv

Question

in Azure Data Studio there's a setting called queryEditor.results.saveAsCsv.delimiter that allows the user to choose the default delimiter when exporting query results in a csv file. However, I'm struggling to find a way to set this property to use a tab as a delimiter; i tried \t, but it seem that the property only accepts 1 single character, so it considers only \. I searched a lot and couldn't find any solution. Any ideas?

Answer 1

Make sure you're placing the escaped character in double quotes

"queryEditor.results.saveAsCsv.delimiter": "\t",

I don't think it accepts one character, I wanted my CSV exports to have a record for each line so my line separator needs be CRLF on a Windows machine. It's set to:

"queryEditor.results.saveAsCsv.lineSeperator": "\r\n",