I Have many many many lines of data coming in in the following format.

2013-03-05, 09:00:55, On, No Crtns, -43.89830128, 171.76788412, 101.043, 0.006, 0.0, $161746:+00619E:+00000N1:+03076+03259+19009+06830:11540:29297:-001-297

I need a way to split them into the following format with each group in its own cell.

41338 0.375636574 On No Crtns -43.89830128 171.76788412 101.043 0.006 0.0 161746 +00619E +00000N1 +03076 +03259 +19009 +06830 11540 29297 -001-297 171.7678841 101.043 0.006 0 161746 +00000N1 +03076 +03259 +19009 +06830 11540 29297 -001 -297

Thanks

Cheers Daryl