I had some messy data to turn tidy. Column of data that needed to be separated into two columns. All the directions where obscure and not helpful. Try searching for a regular expression on the web.
One of the things I was puzzled over was \\.+ found out it meant gosub(). Much easier to search on. Delimiter was another puzzling thing until I realized that I could treat it the same as when I read csv files. This is the R code that worked.
tidymessydata <- (separate(messydata, State.ZIP, into = c(“State”,”Zip”), sep = ” “))
separate is a function
messydata is the data.frame and State.Zip is the column that should be two.
into is the new column names
sep is the delimiter function, space is what it was separated on. I pressed the space bar between the quotation marks.
Hopefully this is clearer than what I found for directions.