Help with string manipulation

[Jon_Stephenson]

Can one of you skilled gurus help me with a formulae to convert this:

…ttps://steamcommunity.com/id/bitcointrader101/

(dots added at start and ‘h’ removed to stop post covering into embed)
(everything up to and including “.com/id/” will remain static - the characters following will vary in type and length)

To this please?

https%3A%2F%2Fsteamcommunity.com%2Fid%2Fbitcointrader101%2F

Thank you

[kuovonne]

Are you looking for ENCODE_URL_COMPONENT()?

[Jon_Stephenson]

No idea that existed - Thank you, exactly what I was after!