Hi, Try: dat1 <- read.table(text="'1 > TC' 'WC' '2 > 0' 'Instruments & Instrumentation; Nuclear Science & Technology;Physics, Particles & Fields; Spectroscopy' '3 > 0' 'Nanoscience & Nanotechnology; Materials Science,Multidisciplinary; Physics, Applied' '4 > 2' 'Physics, Nuclear; Physics, Particles & Fields' '5 > 0' 'Chemistry, Inorganic & Nuclear' '6 > 2' 'Chemistry, Physical; Materials Science, Multidisciplinary;Metallurgy & Metallurgical Engineering'",sep="",header=F, stringsAsFactors=F)
library(data.table) Using `cSplit()` from https://gist.github.com/mrdwab/11380733 cSplit(dat1, "V2", ";", "long") V1 V2 1: 1 > TC WC 2: 2 > 0 Instruments & Instrumentation 3: 2 > 0 Nuclear Science & Technology 4: 2 > 0 Physics, Particles & Fields 5: 2 > 0 Spectroscopy 6: 3 > 0 Nanoscience & Nanotechnology 7: 3 > 0 Materials Science,Multidisciplinary 8: 3 > 0 Physics, Applied 9: 4 > 2 Physics, Nuclear 10: 4 > 2 Physics, Particles & Fields 11: 5 > 0 Chemistry, Inorganic & Nuclear 12: 6 > 2 Chemistry, Physical 13: 6 > 2 Materials Science, Multidisciplinary 14: 6 > 2 Metallurgy & Metallurgical Engineering A.K. On Friday, July 4, 2014 9:53 AM, João Azevedo Patrício <joao.patri...@gmx.pt> wrote: Hi, I've been trying to solve this issue but with no success. I have some data like this: 1 > TC WC 2 > 0 Instruments & Instrumentation; Nuclear Science & Technology; Physics, Particles & Fields; Spectroscopy 3 > 0 Nanoscience & Nanotechnology; Materials Science, Multidisciplinary; Physics, Applied 4 > 2 Physics, Nuclear; Physics, Particles & Fields 5 > 0 Chemistry, Inorganic & Nuclear 6 > 2 Chemistry, Physical; Materials Science, Multidisciplinary; Metallurgy & Metallurgical Engineering And I need to have this: 1 > TC WC 2 > 0 Instruments & Instrumentation 2 > 0 Nuclear Science & Technology 2 > 0 Physics, Particles & Fields 2 > 0 Spectroscopy 3 > 0 Nanoscience & Nanotechnology 3 > 0 Materials Science, Multidisciplinary 3 > 0 Physics, Applied 4 > 2 Physics, Nuclear 4 > 2 Physics, Particles & Fields 5 > 0 Chemistry, Inorganic & Nuclear 6 > 2 Chemistry, Physical 6 > 2 Materials Science, Multidisciplinary 6 > 2 Metallurgy & Metallurgical Engineering This means repeat the row for each element in WC and keeping the same value in TC. The goal is to check how many TC (sum) there are by WC, when WC is multiple. i've tried to separate the column using strsplt but then I cannot keep the track of TC. thanks in advance. -- João Azevedo Patrício Tel.: +31 91 400 53 63 Portugal @ http://tripaforra.bl.ee "Take 2 seconds to think before you act" ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.