Extracting URL's from Hyperlinks

While importing some text to a Coda doc, I stumbled upon the fact that it is quite difficult to get at the URL of a hyperlink if it has display text that is not the URL itself. There is no ‘ExtractURL()’ formula or equivalent for this purpose.

After some playing around, I have come up with a workaround that relies on the hidden _Merge() formula to get at the link object’s data. You can see how to do so here:

Hope it’s helpful!

15 Likes

Dear @Noah,

Welcome to the community :handshake: your share is of great value :diamond_shape_with_a_dot_inside:

4 Likes

Welcome @Noah!

That’s a really cool solution. I never would have found that on my own.

Thanks a ton for posting!

3 Likes