Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

URLDecode

mborriero
11 - Bolide

Hi,

 

I am trying to find a solution to decode an URL string.

 

for example, if I have a string %28White_Background%29 I would like to decode it in (White_Background).

 

I had a look around the community without success.

 

Is there any Macro or an easy way to do that?

6 REPLIES 6
JoeS
Alteryx Alumni (Retired)

Hi @mborriero,

 

There isn't currently a macro or function that I could find either. 

 

I had a look around and there are a few websites that do it for you. I chose urldecode.org/ and have incorporated it within a download tool. The result you want is contained in the field "DecodedURL"

 

06-07-2017 16-13-49.png

 

Please see the workflow attached below as well

jdunkerley79
ACE Emeritus
ACE Emeritus

Attached simple decoder workflow

 

Basically, makes the ASCII character set and encodes then uses find and replace to decode.

 

 

mborriero
11 - Bolide

Unfortunately you both are using a new version of Alteryx.

 

@JoeSThanks, I have also used the same approach, but I wanted to build something that could work offline as well.

 

@jdunkerley79Could you please create the same workbook with an older version of Alteryx? I am interesting to see your solution.

jdunkerley79
ACE Emeritus
ACE Emeritus

Attached in 10.5 format

mborriero
11 - Bolide

@jdunkerley79This is a very good way to do it! Never stop to learn. Thanks.

mborriero
11 - Bolide

Did not mean to accept all as solution! Is there a way to "un-accept"?

Labels
Top Solution Authors