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.