split string into multiple rows with multiple columns

i have a string with user information. I have to write a function that takes string as input and inserts into some table.

Input string contains multiple rows with multiple columns like following

inputString= "1,cassey,1222,12-12-12:2,timon,,02-02-12:3,john,3333,03-03-12"

what i want is to create insert from this...

any one has idea, how it can be achieved????