Re: [R] how to separate string from numbers in a large txt file

2019-05-19 Thread Michael Boulineau
> {3} (\\w+ Back to earlier: > The rest of the line is not substituted and appears as-is. Is that due to the space after the \\2? in > "\\1<\\2> " Notice space after > and before " Michael On Sun, May 19, 2019 at 2:31 PM Boris Steipe wrote: > > Inline

Re: [R] how to separate string from numbers in a large txt file

2019-05-19 Thread Michael Boulineau
er with : for 8 characters, followed by any two words separated by a space and enclosed in <>. And then the \\s* is followed by a single space? Or maybe it puts space on both sides (on the side of the #s to the left, and then the comment to the right). The (.+)$ is anything whatsoever un

Re: [R] how to separate string from numbers in a large txt file

2019-05-18 Thread Michael Boulineau
text > 1 2016-01-27 09:14:40 Jane Doe started a video chat > 2 2016-01-27 09:15:20 Jane Doe https://lh3.googleusercontent.com/ > 3 2016-01-27 09:15:20 Jane Doe Hey > 4 2016-01-27 09:15:22 John Doe ended a v

Re: [R] how to separate string from numbers in a large txt file

2019-05-18 Thread Michael Boulineau
: > > patt <- " <\\w+ \\w+> " #" " > sum( ! grepl(patt, tmp))) > > ... will give the number of lines that remain in your file that do not have a > tag that can be interpreted as "Who" > > Once that is fine, use Bill's approach

Re: [R] how to separate string from numbers in a large txt file

2019-05-17 Thread Michael Boulineau
come from the byte > >order > >mark that Windows apps like to put at the front of a text file in UTF-8 > >or > >UTF-16 format. > > > >Bill Dunlap > >TIBCO Software > >wdunlap tibco.com > > > > > >On Fri, May 17, 2019 at 11:53 AM Michael

Re: [R] how to separate string from numbers in a large txt file

2019-05-17 Thread Michael Boulineau
gt; What="")) > > str(z) > 'data.frame': 4 obs. of 3 variables: > $ When: chr "2016-10-21 10:35:36" "2016-10-21 10:56:29" "2016-10-21 > 10:56:37" NA > $ Who : chr "" "" "" NA > $ What:

Re: [R] how to separate string from numbers in a large txt file

2019-05-16 Thread Michael Boulineau
997] "//1,//2,//3,//4" [998] "//1,//2,//3,//4" [999] "//1,//2,//3,//4" [1000] "//1,//2,//3,//4" up until line 1000, then I reached max.print. Michael On Thu, May 16, 2019 at 1:05 PM David Winsemius wrote: > > > On 5/16/19

Re: [R] how to separate string from numbers in a large txt file

2019-05-16 Thread Michael Boulineau
e time of day isn't so important. But, especially since, say, Gmail itself knows how to quickly recognize what it is, I know it can be done. I know this data has structure to it. Michael On Wed, May 15, 2019 at 8:47 PM David Winsemius wrote: > > > On 5/15/19 4:07 PM, Michael

[R] how to separate string from numbers in a large txt file

2019-05-15 Thread Michael Boulineau
I have a wild and crazy text file, the head of which looks like this: 2016-07-01 02:50:35 hey 2016-07-01 02:51:26 waiting for plane to Edinburgh 2016-07-01 02:51:45 thinking about my boo 2016-07-01 02:52:07 nothing crappy has happened, not really 2016-07-01 02:52:20 plane went by pretty fast,