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}}
______________________________________________
[email protected] 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.
