Hi, I would like to use the separate function and extract information that is inside brackets in a character into another column.
This is my code so far, however, I just cannot figure out the correct code for the sep to only extract the information from inside the brackets.
SurveyMonthly_2010_10 <- SurveyMonthly_2010_10 %>%
separate(
col = ClosefriendsWestgate,
into = c("ClosefriendsWestgate_label", "ClosefriendsWestgate_percentage"),
sep = "([\.\?\:])"
)
Can someone help me out with this one? Thanks!