Convert Base64 Strings to Numbers

[needknimehelp]

Hallo everyone,

I currently have data in columns in Base64 format and I want to decode it with KNIME into “real” numbers. Is there a way to do it in KNIME? I already tried the “Base64 to String”-Node, but this only returns empty cells.

Thank you in advance"

[ipazin]

Hello @needknimehelp,

there are Base64 Encoder & Decoder nodes available in Palladian extension. Maybe they’ll work for you.

Base64 Decoder — NodePit

Base64 Encoder — NodePit

Br,
Ivan

[mlauber71]

@needknimehelp then there is this

alexanderfillbrunn/Public – Base64

[needknimehelp]

thank you for your answer. Unfortunately Iam not allowed to install external packages like that

[needknimehelp]

thank you for your answer aswell. I can not use that Node since I can not update KNIME to the newest version.

[needknimehelp]

Does anyone maybe have a solution for Java snippet node?

[ipazin]

Hello @needknimehelp,

check this topic:

Convert Binary To Base64

Hey All! I am been really struggling on this problem and thought it was time to reach out. I need to convert a KNIME Binary Object (an image binary return from an API) to a Base64 string so I can use it in PowerBI to display an image in a dashboard. I have tried everything I can think of to get the Binary to Base 64 and I have been unsuccessful. I need to end up with a string output something like this: /9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEB…

There’s some Java code and links to additional resources.

Br,
Ivan