Help with string manipulation

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


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

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.