Converting from BINARY to STRING is available directly on On-Prem system.
But the same is not available on EMS or I am missing out on the feature.
Can you please suggest a good way to CONVERT BINARY to STRING.
I do not want to CAST AS STRING as that doesn't help. I need to CONVERT BINARY to STRING
Hello,
you can try "BITSTRING_TO_BINARY" function - changes '0110000101100010' to 'ab'
Let us know it that worked :)
Best Regards,
Mateusz Dudek
Hi Mateusz,
This function "BITSTRING_TO_BINARY" is not available in our EMS to be used.
Can we get that enabled to be used?
Let me add another scenario to this.
The Binary is in the form of VARBINARY (ie Encrypted).
Now that we need to convert this VARBINARY to STRING by decrypting
Hello,
Sorry, it seems to be Vertica 10.0.x function but it's not supported in CELONIS. I've also tried some PQL functions but i couldn't find naything that could help. Only thing i can think of is to user ML workbench and the python to convert these values.
Maybe it would be good idea to propose adding/enabling such option?
Let me know if you'll have any updates.
Best Regards,
Mateusz Dudek
Yes Mateusz. This is what we have been struggling with.
I will raise a ticket for adding a feature for it if not already available.
Thanks for your time though for trying out the same. Appreciate it.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
