Split a column in R into two

Question

I have a column in my data frame having values like

I want the resultant Dataframe of the format:

@Frank I will remove the regex tag shortly. – www Aug 28 '17 at 16:52 — www, Aug 28 '17 at 16:52

Balter · Accepted Answer · 2017-08-28T16:52:06.887

2

DF$Col5 <- gsub('/.*?/','', DF$Col1)

edited Aug 28 '17 at 16:52

answered Aug 28 '17 at 16:41

Balter

1

Had an extra dot. – acylam Aug 28 '17 at 16:46
1

Seems bizarrely dependent on the length of the path. Tbh, I have no idea how it's meant to work but it fails with...`gsub('/.*?/','', c("/A/B/C/abc", "/abc"))`. Probably, you just want the `basename` function. – Frank Aug 28 '17 at 16:49
1

Thanks for the heads up on the dot. Frank, I assumed these were not file paths and were a list of companies or something in the strict format listed. – Balter Aug 28 '17 at 16:54
1

@Frank The multiple slashes in your example would require a different pattern. Balter's solution matches the first forward slash, then more than one of any character, until another forward slash is matched. – Mako212 Aug 28 '17 at 16:55
@Mako212 Ok, thanks, I get it now. – Frank Aug 28 '17 at 16:56
@Frank Check my updated answer for matching your example – acylam Aug 28 '17 at 17:25
Yeah, that's better / more general (assuming I'm right about what the OP is after). Thanks – Frank Aug 28 '17 at 18:28

1 Answers1