URLDecode

[mborriero]

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?

[JoeS · Accepted solution]

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"

Please see the workflow attached below as well

[jdunkerley79 · Accepted solution]

Attached simple decoder workflow

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

[mborriero · Accepted solution]

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 · Accepted solution]

Attached in 10.5 format

[mborriero]

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

[mborriero]

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