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.