Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

create CSV (comma separated) including a tab within one field

NatSnook
8 - Asteroid

Hi All

Is it possible to create a csv file which is comma separated and all fields quoted which also contains a tab space within one field?

whenever i output the tab seems to be converted to a single space.

 

eg "something[tab]here" is output as "something here" losing the [tab]

 

hope that makes sense? TIA

 

 

3 REPLIES 3
DataCurious_Shaan
7 - Meteor

Hi @NatSnook 

 

Attached is an example. In Alteryx you may first have to insert the tab using a formula tool:

[Field1]+CharFromInt(9)+"here" - using the charfromint(9)

then in the output tool saying quote output fields select always. This puts quotes around any field. In my output I get:

DataCurious_Shaan_0-1625147068939.png

 



I have also attached my workflow
Hope this solves your issue
Kind regards
Shaan

NatSnook
8 - Asteroid

legendary!! thanks so much🏅

DataCurious_Shaan
7 - Meteor

@NatSnook glad I could help

Labels