Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Newline Character + Tab-Delimited

trevorwightman
8 - Asteroid

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?

2 REPLIES 2
ChrisTX
15 - Aurora

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?

ChrisTX_0-1660150118590.png

 

 

Chris

SPetrie
12 - Quasar

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.

SPetrie_0-1660150229153.png

 

Labels