Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
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
Alteryx

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

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

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