Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer 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
14 - Magnetar

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
11 - Bolide

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