Your pattern seems ... way overboard? Why not gsub("-", "", tb2a$TID)
On March 15, 2019 12:45:27 PM PDT, 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 <- > >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. -- Sent from my phone. Please excuse my brevity. ______________________________________________ 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.