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

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

Output

Accepted answers

DataCurious_Shaan

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

Example_DatacuriousShaan.yxmd

All comments

DataCurious_Shaan

Hi @NatSnook

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

Example_DatacuriousShaan.yxmd

NatSnook

legendary!! thanks so much🏅

DataCurious_Shaan

@NatSnook glad I could help

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335