removing \r\n\r\n at the very beginning AND at the very end in a string using r

Question

I want to remove \r\n\r\n before and after each string in a column

df = data.frame(names = c("\r\n\r\n17-Hydroxyprogesterone\r\n\r\n", "\r\n\r\n5-HIAA\r\n\r\n", "\r\n\r\nAcetaminophen\r\n\r\n", "\r\n\r\nAcetylcholine Receptor (AChR) Antibody\r\n\r\n"))

Expected output

names
n17-Hydroxyprogesterone
5-HIAA
Acetaminophen
Acetylcholine Receptor (AChR) Antibody

Fairly straightforward. What have you tried? – Rich Scriven Feb 01 '18 at 05:10 — Rich Scriven, Feb 01 '18 at 05:10
`df$names <- trimws(df$names)` – alistaire Feb 01 '18 at 05:47 — alistaire, Feb 01 '18 at 05:47

Matt W. · Accepted Answer · 2018-02-01T05:15:34.467

1

Using Base R Try:

df$name <- gsub(“r\\n\\r\\n”, “”, df$name)

Using dplyr:

df <- df %>%
           mutate(name = gsub(“r\\n\\r\\n”, “”, name)

edited Feb 01 '18 at 05:15

answered Feb 01 '18 at 05:12

Matt W.

3,692
2
23
46

2

Or `"[\r\n]"` for `pattern` – Rich Scriven Feb 01 '18 at 05:13

removing \r\n\r\n at the very beginning AND at the very end in a string using r

1 Answers1