Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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