Hello,
Here are 2 examples, one with stringr::str_remove_all and the other with
base gsub. I am assuming that you want to remove the spaces from column
'servicer'.
dat <- data.frame(x = rnorm(2),
servicer = c("a b c", " d efg"),
fctrdt = 1:2)
dat
library(dplyr)
library(stringr)
dat %>%
select(fctrdt, servicer) %>%
mutate(servicer = str_remove_all(servicer, "[[:space:]]"))
dat %>%
select(fctrdt, servicer) %>%
mutate(servicer = gsub("[[:space:]]", "", servicer))
Hope this helps,
Rui Barradas
Às 14:42 de 01/03/20, Glenn Schultz via R-help escreveu:
All,
This may not be the proper place to ask as the question is dplyr and
removing white space using mutate. My code is below:
```{r, echo = FALSE, message = FALSE
conn <- myconnection
````
```{r, echo = FALSE, message=FALSE}
fhlloanbalance <- tbl(conn, "fhlloan_balance_view")
colnames(fhlloanbalance)
```
```{r, echo=FALSE, message=FALSE}
fhlloanbalance %>%
select(fctrdt, servicer) %>%
filter(fctrdt == '2020-01-01') %>%
mutate(servicer = 'I need to remove all white space')
```
I have tried a number of approaches using stringr - stringi - and gsub.
The problem I think I am facing: I cannot seem to operate on the
column in sql this is relative straight forward using replace. I have
tried several approaches and scanned the internet but I cannot seem to
come up with a workable solution. Any help is appreciated. I suppose I
could just default back to sql but would prefer to use dplyr.
Best,
Glenn
______________________________________________
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.
______________________________________________
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.
