In data frame how to spilt strings into values

Question

Here is a data frame which consist of character variable "SAP"

 ID                  VAR
1  4 SAP1\r\nSAP2\r\nSAP8
2  5         SAP2\r\nSAP5

I would like to split the variable -\r\n and obtain the desired dataframe:

  ID  VAR
1  4 SAP1
2  4 SAP2
3  4 SAP8
4  5 SAP2
5  5 SAP5

Answer 1

We can easily do this with separate_rows() function

library(tidyr)
separate_rows(df, VAR, sep='\\s+')

Answer 2

You can do this using dplyr and tidyr:

library(dplyr)
library(tidyr)
v %>% 
  mutate(string_name = strsplit(as.character(string_name), ",")) %>%
  unnest(string_name)