Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Decoder for Base 64 Encoder Tool?

Highlighted
Alteryx Partner

Hey !

 

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

 

Mathias

 

 

Highlighted
16 - Nebula
16 - Nebula

Try the attached macro.

 

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

Highlighted
Alteryx Partner

Hey,

thank you for your support.

 

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

Mathias

 

 

Highlighted
16 - Nebula
16 - Nebula

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.

Highlighted
16 - Nebula
16 - Nebula

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):

2016-04-16_16-58-46.jpg

Will throw together an encoder macro like the decoder one

Highlighted
16 - Nebula
16 - Nebula

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

Alteryx
Alteryx

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

Highlighted
8 - Asteroid

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?

Highlighted
8 - Asteroid

@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?

Labels