I have this string
Declare @x nvarchar(10) = '1|2:1|3|4:2'
I want to divide these values between two strings
StringOne='1,2,3,4' //here i took each number before semi coloum
StringTwo= '1,2' //here i took each number after semi colon
What I have tried:
How can i split the first string into two strings.. I should split by '|' and ','