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:
but the output I am getting is:
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
If you're just building a string using concatenation, simply use ... + "NUL" + "NUL" + ... etc instead of CharFromInt(0), like this:
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.
