Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Not able to print NUL character which is also ASCII(0) in alteryx output file

Rajendrasharma
5 - Atom

Hi Team,

 

Please help me to print NUL character in Alteryx output, I need to this to create SWIFT MX message.  The output I need is as below:

 

Rajendrasharma_0-1762236254243.png

 

but the output I am getting is: 

 

Rajendrasharma_1-1762236309266.png

 

Alteryx Code for the above is:

CharFromInt(31)+"006303"+ CharFromInt(0) + CharFromInt(0) + CharFromInt(0)+CharFromInt(0)+CharFromInt(0)+CharFromInt(0)+CharFromInt(0)+CharFromInt(0)+CharFromInt(0)+CharFromInt(0)+CharFromInt(0)+CharFromInt(0)+CharFromInt(0)+CharFromInt(0)+CharFromInt(0)+CharFromInt(0)+CharFromInt(0)+CharFromInt(0)+CharFromInt(0)+CharFromInt(0)+CharFromInt(0)+CharFromInt(0)+CharFromInt(0) + '<?xml version="'+ '1.0'+'" encoding="UTF-8"?>'

 

but its not able to print NUL character in output.  

 

Please do let me know for any further details required.  Thanks

 

 

3 REPLIES 3
jrlindem
12 - Quasar

If you're just building a string using concatenation, simply use ... + "NUL" + "NUL" + ... etc instead of CharFromInt(0), like this:

 

jrlindem_0-1762264099972.png

 

binu_acs
21 - Polaris

@Rajendrasharma have you tried Python? 

binu_acs_0-1762276766974.png

 

stevemarkovick
7 - Meteor

The NUL character (ASCII 0) can’t be printed because it’s a control character used to mark the end of a string, not an actual visible symbol. In Alteryx, you’ll need to handle it by replacing or removing it using regex or a formula tool. Exporting to binary-safe formats sometimes preserves it for specific data processing needs.

Labels
Top Solution Authors