Output file delimiter

Hi all,

Have a question about output file tool and setting non-standard delimiters.

How do you set as a delimiter in an output file?

I believe it is the End Of Transmission (EOT) ASCII code 004, so as a regex character it is [\x04]. Below is what was attempted but it causes the whole Alteryx workflow to error.

Thanks in advance

Regex

Output

Accepted answers

PhilippK

Hi Patrick,

configure your Output Data tool like that:

Let me know whether this helps you.

Best regards

Phil

All comments

PhilippK

Hi Patrick,

configure your Output Data tool like that:

Let me know whether this helps you.

Best regards

Phil

patrickfalconer

Thanks Phil,

Tried it:

but got an error saying it must be a single character:

any thoughts on how I get around the error?

PhilippK

hm at my side it works..can you share your workflow and (sample) data?

then I'll have a closer look.

patrickfalconer

It works, thankyou!

The issue was capital X vs small x:

Thanks Phil - you just made my life considerably easier!

atcodedog05

@patrickfalconer

I think it was more of a back slash(\) forward slash(/) issue. Maybe

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

michael_weaver 335

Hollingsworth 335