I would like to convert comma-delimited values into rows in Redshift

For example:

```
store  |location |products
-----------------------------
1      |New York |fruit, drinks, candy...

```

The desired output is:

```
store  |location | products
------------------------------- 
1      |New York | fruit        
1      |New York | drinks         
1      |New York | candy     

```

Are there any simple solution that I could split the words based on delimiters and convert into rows? I was looking into this solution but it does not work yet: <https://help.looker.com/hc/en-us/articles/360024266693-Splitting-Strings-into-Rows-in-the-Absence-of-Table-Generating-Functions>

Any suggestions would be greatly appreciated.