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

[NatSnook]

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

[DataCurious_Shaan · Accepted solution]

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:

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

[NatSnook]

legendary!! thanks so much🏅

[DataCurious_Shaan]

@NatSnook glad I could help