How to split a string with multiple characters into seperate columns in SQL?

I have a table which looks like this:

I’m trying to figure out how to get seperate the dashes to get different values into different columns. So the first word before the first dash (‘-‘) would populate the ‘Company’ column. I would also like to get the word after the first dash and populate that into the ‘City’ column. Finally, I would also like to get the last part of the string after the second dash to populate that into my ‘Country’ column.

So the goal is to have the table updated like this:

Is this possible? Some of the values in the Customer_Group field either have a white space or no white pace before and after the dash (‘-‘) character but I was also hoping to remove the white space that may appear before the word when it is inserted into the new columns.

>Solution :

Using INSTR(), SUBSTR and TRIM

UPDATE your_table
SET Company = TRIM(SUBSTR(Customer_Group, 1, INSTR(Customer_Group, '-') - 1)),
    City = TRIM(SUBSTR(Customer_Group, INSTR(Customer_Group, '-') + 1, INSTR(Customer_Group, '-', INSTR(Customer_Group, '-') + 1) - INSTR(Customer_Group, '-') - 1)),
    Country = TRIM(SUBSTR(Customer_Group, INSTR(Customer_Group, '-', INSTR(Customer_Group, '-') + 1) + 1))