SQL Query (Data Manupilation--URGENT)

Hi Guys,

Can you please help me on resolving this puzzle. I will appreciate your help.

At the botton is the data in one of the column (combined) in one of the table.

I need to split these data and insert into 4 different columns.

Structure of the data is this:
eg: if we take the first value in the following description ie: n1^m1^d1^s1
contains 4 different values for the future insert eg: n1 goes to Name column, m1 goes to Title column, d1 goes to Date column and S1 goes to salary column (This is grate).

And this information is separated by ^.
But This combined column can have multiple values for several employees
such as in 2nd value in the following data ie: n2^m2^d2^s2~n3^m3^d3^s3
(this is grate too). here n2 is a employee Name where as n3 is another employee name. These set of data is differentiated by ~.

This combined column can have multiple no of employees information (separted by ~).

Note: The employee may have some of the information missing in its corosponding set of data such as if you look at the 4th set of data, ie:
n5^^^. here we only have employeename information not other informations.
another eg: if we take the last row
ie: n7^^^~n8^^d8^~n9^m9^^~n10^^^s10
second set of data (n8^^d8^) has name(n8),null value for Title,d8 value for date,null value for salary.

So in a nutshell I need to split this data and load into 4 different columns in that table. which data goes which column is totally depend on the ^ and ~ separators.

For eg:
1) The output for the first row data should be like:: for name n1, for title m1,for date d1, for salary s1

2)The output for n6^m6^d6^ should be like : for name n6,for title m6, for date d6, for salary null

Thanks guys, This is making my head spin already and can you guys take a spin of this problem and help me.

Once again thanks for your help.

combined
--------
n1^m1^d1^s1

n2^m2^d2^s2~n3^m3^d3^s3

n4^m4^d4^s4~n4^m4^d4^s4~n5^m5^d5^s5

n5^^^

n6^m6^d6^

n7^^^~n8^^d8^~n9^m9^^~n10^^^s10