Regexextract multiple results?


I'm trying to extract all links from a specific column that contains html code. Each field can contain multiple links so the goal is to have one row per extracted link.

I created a custom field with regexextract([Post Content], "<a[^>]*>[^<]*</a>") but it only seems to extract the first link and not all links.

Is my goal actually achievable with Metabase?

Thanks for the help!

Hi @wwwoda
You would have to use SQL, since it would cause multiple rows, which the Custom Column was not built to handle.

Thanks for the quick answer @flamber

So you mean use the SQL Query function in Metabase and create the table like that?

@wwwoda Yes, use SQL to basically ETL the results you want: