This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!
Hello,
I have a client asking for a file be delivered with the following specifications:
Newline character present between each row
Tab-delimited, using double-quote characters for quoting fields
I know I can output as new line (\n) or tab-delimited (\t) but not sure how to satisfy both.
Any idea how I can configure the output tool to satisfy this request?
If you output to a CSV format (you could use any file extension like .TXT), wouldn't the "newline between each row" be the default?
And just specify \t to be the field separator.
I'm guessing "newline" is represented by CRLF (carriage return and line feed) ASCII characters?
Do these options give you the correct output format?
Chris
Adding to what @ChrisTX mentioned, you can ensure your double quotes by changing "Quote output fields" to always. Saving a file in this format does put CRLF at the end of each line.