Splitting Columns

Hi All,

I'm looking to be able to split columns in metabase as you would on other applications.
This is because of columns containing a number that would be key for creating analytics or joins, but the extra text in the column prevents that use. As far as I can see in the documentation, it's not possible through custom columns but feel it would be a useful function.

Any help and advice appreciated.

Hi @Matt1
Why ain't you able to use these functions?
https://www.metabase.com/docs/latest/users-guide/expressions-list.html#substring
https://www.metabase.com/docs/latest/users-guide/expressions-list.html#regexextract
It will not change the case, so you would likely need to also convert your numeric column to a string with something like concat([num_col], ""), so you can match the two.

But performance will not be as great is if you had a better data model, which didn't require something like this and could make us of indexes too, but shouldn't be a problem on smaller databases.