Regexextract multiple results?

Get Help
1

Hi,

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!

2

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

3

Thanks for the quick answer @flamber

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

4

@wwwoda Yes, use SQL to basically ETL the results you want: https://www.metabase.com/docs/latest/questions/native-editor/writing-sql