I am just starting DBA and curious about how can I split entire column with data like: "1-2/456/£25.00-26.00/56/10+". My delimiter is "/" and I need to get data in 5 columns accordingly. So data to be displayed as: Col01: 1-2; Col02: 456; Col03:£25.00-26.00, Col04:56; Col05: 10+. I tried Jeff Moden, but it splits data to rows, not to columns. I am struggling to link function to use data from column, not just values.
SELECT * FROM [dbo].[DelimitedSplit8K]('Masha/Sasha/Nadia/Loki','/')
So I actually need column instead of 'Masha/Sasha/Nadia/Loki' and convert to columns, not rows.