Output file delimiter

[patrickfalconer]

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

[PhilippK · Accepted solution]

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

[PhilippK]

@atcodedog05  good catch! 🙂

[patrickfalconer]

You are right, it now works for me with lower case x. Maybe something reset?

Regardless, thanks for the help and hopefully it will continue to work!

Best,

Patrick

[patrickfalconer]

yep, backslash / vs forward slash \  my bad. Thanks!