[R] Help with gsub function

[Jeff Newmiller]

Your pattern seems ... way overboard? Why not

gsub("-", "", tb2a$TID)

On March 15, 2019 12:45:27 PM PDT, Bill Poling <Bill.Poling using 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 using 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.