You can extract the URL or title, but I don’t think you can’t embed a URL within the title like you did in your post, at least not in a URL field. Both URL and titles have to be in their respective fields. There are a few ways to do it, the easiest being a script, but if you want to just use formula fields, I think the MID function can help you:
[Mid] function lets you extract a certain number of characters starting at a specific place within a string. It follows this format: MID(string, whereToStart, count).
The variables are:
string: Your anchor tag
whereToStart: Right after the “=“ symbol
count: Distance between whereToStart and where the URL ends (right before the “>” symbol)
So, you will need to figure out the starting position and count (distance from start to end):
- Starting position right after the “=“: FIND("=", {Anchor Tag}) + 1
- Ending position right before the “>“: FIND(">", {Anchor Tag})
- To get the count, you need the distance between (2) & (1), so subtract (2) - (1): FIND(">", {Anchor Tag}) - (FIND("=", {Anchor Tag}) + 1)
Putting it all together:
MID({Anchor Tag}, FIND("=", {Anchor Tag}) + 1, FIND(">", {Anchor Tag}) - (FIND("=", {Anchor Tag}) + 1))
Here’s a link to a base with everything put together. I’ll leave it up for a few days:
Zemanir Airtable Consulting: www.zemanir.com
