Inspire EMEA 2022 On-Demand is live! Watch now, and be sure to save the date for Inspire 2023 in Las Vegas next May.

Alteryx Designer Discussions

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

Decoder for Base 64 Encoder Tool?

mathias_schnoor
11 - Bolide

Hey !

 

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

 

Mathias

 

 

11 REPLIES 11
jdunkerley79
ACE Emeritus
ACE Emeritus

Try the attached macro.

 

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

mathias_schnoor
11 - Bolide

Hey,

thank you for your support.

 

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

Mathias

 

 

jdunkerley79
ACE Emeritus
ACE Emeritus

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
ACE Emeritus
ACE Emeritus

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

jdunkerley79
ACE Emeritus
ACE Emeritus

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

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

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

AndrewCrayford
8 - Asteroid

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

Labels