Good morning Peter, yes that works fine. My attempt was based on a google
search that looked promising but was obviously more complicated than it needed
to be.
Thank you.
WHP
From: Peter Langfelder <peter.langfel...@gmail.com>
Sent: Friday, March 15, 2019 3:53 PM
To: Bill Poling <bill.pol...@zelis.com>
Cc: r-help (r-help@r-project.org) <r-help@r-project.org>
Subject: Re: [R] Help with gsub function
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 <mailto: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}}
>
> ______________________________________________
> mailto: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.
Confidentiality Notice This message is sent from Zelis. This transmission may
contain information which is privileged and confidential and is intended for
the personal and confidential use of the named recipient only. Such information
may be protected by applicable State and Federal laws from this disclosure or
unauthorized use. If the reader of this message is not the intended recipient,
or the employee or agent responsible for delivering the message to the intended
recipient, you are hereby notified that any disclosure, review, discussion,
copying, or taking any action in reliance on the contents of this transmission
is strictly prohibited. If you have received this transmission in error, please
contact the sender immediately. Zelis, 2018.
______________________________________________
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.
