Decoder for Base 64 Encoder Tool?

[mathias_schnoor]

Hey !

How is it possible to decode an encoded string by using the Base 64 Encoder Tool?

Mathias

[jdunkerley79]

Try the attached macro.

It is a quick go at implementing the Base64 decoder in Alteryx

[mathias_schnoor]

Hey,

thank you for your support.

Your macro decode letters. What changes are necessary to decode all characters (like ASCII character set)?

Mathias

[jdunkerley79]

Can you send me some sample and will tune the macro. Just a quick attempt on train this AM think will cope with basic ASCII cases but Unicode beyond it.

[jdunkerley79]

Think there might be an issue in the Alteryx Base64 encoder tool

I think it has an issue when encoding over multiple strings. Looking at a simple case

ABC should encode to QUJD

It seems to have a problem is the length of a row is (1 mod 3):

Will throw together an encoder macro like the decoder one

[jdunkerley79 · Accepted solution]

Pushed an Encoder and Decoder macro to the gallery.

Only good for ASCII - will do a unicode one in my .net tools - but think covers the use case we talked over

Encoder: https://gallery.alteryx.com/#!app/Base64Encoder/571296853df7da0a388484b1

Decoder: https://gallery.alteryx.com/#!app/Base64Decoder/57129662a248970ba8b755ae

[MarkG]

Hi Mathias,

I believe you can also you the Blob Convert tool. 

1) You will encode the text with the Base64 tool

2) Convert the Base64_encoded field to a blob field via the Blob Convert tool

3) Use another Blob Convert tool to convert From a Blob Field

[AndrewCrayford]

I already got some base 64 code which I need to de code to Unicode or utf-8, is there a way i can do it?

[AndrewCrayford]

---

@jdunkerley79 wrote:

Pushed an Encoder and Decoder macro to the gallery.

Only good for ASCII - will do a unicode one in my .net tools - but think covers the use case we talked over

Encoder: https://gallery.alteryx.com/#!app/Base64Encoder/571296853df7da0a388484b1

Decoder: https://gallery.alteryx.com/#!app/Base64Decoder/57129662a248970ba8b755ae

---

I was wondering have you got a decoder that convert base64 to unicode or utf-8 text?

[AndrewCrayford]

Just wondering if there a decoder for Base64 into utf-8?