SQL/Beast Mode to extract substrings and output to multiple new columns
I have a column in my data with strings that look like this: Clusters affected:|Finance, Services & Innovation| |Planning & Environment| |Transport & Infrastructure| |Finance, Services & Innovation| |Planning & Environment||Finance, Services & Innovation| |Health| |Industry| |Planning & Environment| |Premier & Cabinet|…