Forum Discussion
pramita
6 years agoHelper II
How to decode URL component using M Language?
I have a column with links in it, I need to decode it. The links are encoded, in %s as shown below For example: https%3A%2F%2Fwww.rnd.de%2Fpanorama%2Fzwei-flugzeuge-stossen-im-munsterland-zus...
AllisonKennedy
6 years agoCommunity Champion
Not quite as elegant as decoding, but you could simply select the column, then do a replace values to find:
%2F
and replace with:
/
And do that again for
%3A
and replace with:
:
%2F
and replace with:
/
And do that again for
%3A
and replace with:
: