How to use unit separator as delimiter in alteryx

I have trying to create a file with unit separator and i m not sure how to do it. I have attached a screen shot of file header. Instead of comma or tab or any other delimiter, I m looking for unit separator as delimiter. Please let me know if i m not clear i will try to provide some more information . Thanks for the help

file_header.PNG

Accepted answers

Claje

I also ran into some challenges getting this to work just using the output tool - particularly because it seems like most windows applications (Alteryx included) don't display this character by default.

There may be a better way to do this, but I've attached a workflow that I believe will support your output format. Basically, by consolidating every row into one field and creating the delimiter using a formula, we can output to a "non-delimited" file using this custom delimiter.

let me know if this helps!

claje_UnicodeDelimiter.yxmd

All comments

Claje

Having never tried this before, try using this as your delimiter:

\u001f

Let me know if that works, or if there's an issue!

msaxen2

It didnt work. It throws an error attached is the error

error.PNG

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15881

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703