If you want to remove just the hyphen, why not do sub("-", "", tb2a$TID)
sub("-", "", "73-017323") [1] "73017323" Am I missing something? Peter On Fri, Mar 15, 2019 at 12:46 PM Bill Poling <bill.pol...@zelis.com> wrote: > > Good afternoon. > > sessionInfo() > #R version 3.5.3 (2019-03-11) > #Platform: x86_64-w64-mingw32/x64 (64-bit) > #Running under: Windows >= 8 x64 (build 9200) > > I am using gsub function to remove a hyphen in a 9 character column of values > in order to convert it to integer. > > Works fine except where the second segment has a leading 0, then it is > eliminating the 0 > > Example "73-0700090" becomes " 73700090" > "77-0633896" becomes "77633896" > > Is there a remedy for this? > > tb2a$TID2 <- gsub(tb2a$TID, pattern="-[0-0]{0,7}", replacement = "") > > head(tb2a$TID,n=10) > [1] "11-1352310" "45-2711804" "35-6001540" "77-0633896" "62-1762545" > "61-1029768" "73-0700090" "47-0376604" "47-0486026" "38-3833117" > > head(tb2a$TID2,n=10) > [1] "111352310" "452711804" "356001540" "77633896" "621762545" "611029768" > "73700090" "47376604" "47486026" "383833117" > > I have googled the problem and have not found a solution. > > http://www.endmemo.com/program/R/gsub.php > http://r.789695.n4.nabble.com/extracting-characters-from-string-td3298971.html > > > Thank you. > > WHP > > Confidentiality Notice This message is sent from Zelis. ...{{dropped:13}} > > ______________________________________________ > R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see > 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 -- To UNSUBSCRIBE and more, see 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.