[R] Help with gsub function

[Bill Poling]

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}}