Parsing strings in Metabase

Get Help
1

Hi all,

I’ve been struggling to try and get this working so i figured id check in here. Im trying to separate a string of data into half a dozen or so columns. I’ve tried the CharIndex route and it didnt work and then I looked into the string_split function but i guess Metabase doesnt support it?

Any other ideas? These are huge strings, over 100 words on average, not sure if that changes things or not.

Thanks!

2

Hi @asutherland8219
Metabase supports a wide range of databases, so this isn’t as simple as it sounds, but you’re welcome to open a feature request about it:
https://github.com/metabase/metabase/issues/new/choose
But you can use SQL questions and make use of any function available in your database.