Hi i have the data in the following format:

rent,100,1,common,674
pipe,200,0,usual,864
car,300,1,uncommon,392:jump,700,0,common,664
car,200,1,uncommon,864:snap,900,1,usual,746
stint,600,1,uncommon,257
pull,800,0,usual,594

where as i want the above 6 lines data into 8 lines as below (Spliting row 3
& 4 at : and sending to a new row):

rent,100,1,common,674
pipe,200,0,usual,864
car,300,1,uncommon,392
jump,700,0,common,664
car,200,1,uncommon,864
snap,900,1,usual,746
stint,600,1,uncommon,257
pull,800,0,usual,594

Request any one who can help me getting this done.

Regards,
Madana

--
View this message in context: http://r.789695.n4.nabble.com/Splitting-one-column-value-into-multiple-rows-tp3668835p3668835.html
Sent from the R help mailing list archive at Nabble.com.
	[[alternative HTML version deleted]]

