I want to split values i a column into n sections considering ~ as the delimiter. And I want to do this for all values in that column assuming the length of characters of each section changes.

lets take ‘147 Spadina Ave~Toronto~CA’ as a value in a column. I want to split them into n sections considering ~ as the delimiter. And I want to do this all values in that column assuming the length of characters of each section changes.

‘147 Spadina Ave~Toronto~CA’ should be split into 3 different strings like below

147 Spadina Ave
Toronto
CA

like this lets say the length changes, for eg next row instead of Toronto it is Vancouver then it should split into

147 Spadina Ave
Vancouver
CA