Help with string manipulation

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

Are you looking for ENCODE_URL_COMPONENT()?

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

1 Like

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.