4 messages · Bob Green, Andrew Robinson, jim holtman +1 more
Hello,
I am hoping for advice as to how I could remove all words immediately following the words 'Mr' or 'Mr.' in a csv file. For example, the following phrases are included in lines of text (along with other Mr) that could be anywhere in the file: "Mr Jones ate lunch" and "Mr Smith was tied". I want to remove the words Jones and Smith (etc) leaving the other text intact. Any suggestions are appreciated, regards Bob
Hi Bob, I recommend doing some background reading on regular expressions[1] and using gsub(). Cheers Andrew [1] http://en.wikipedia.org/wiki/Regular_expressions
Hello,
I am hoping for advice as to how I could remove all words immediately following the words 'Mr' or 'Mr.' in a csv file. For example, the following phrases are included in lines of text (along with other Mr) that could be anywhere in the file: "Mr Jones ate lunch" and "Mr Smith was tied". I want to remove the words Jones and Smith (etc) leaving the other text intact. Any suggestions are appreciated, regards Bob
______________________________________________ R-help at r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
Andrew Robinson Department of Mathematics and Statistics Tel: +61-3-8344-6410 University of Melbourne, VIC 3010 Australia Fax: +61-3-8344-4599 http://www.ms.unimelb.edu.au/~andrewpr http://blogs.mbs.edu/fishing-in-the-bay/
An embedded and charset-unspecified text was scrubbed... Name: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20080920/956258bb/attachment.pl>
x <- 'Mr Jones ate lunch and Mr Smith was tied'
gsub('(Mr\\.*)\\s+\\w+', "\\1 <file://0.0.0.1/> xxxx", x)
[1] "Mr xxxx ate lunch and Mr xxxx was tied"
I don't get what the bit
<file://0.0.0.1/>
is about. If I do (just)
gsub('(Mr\\.*)\\s+\\w+', "\\1 xxxx", x)
I get the desired result, i.e.
[1] "Mr xxxx ate lunch and Mr xxxx was tied"
cheers,
Rolf Turner
######################################################################
Attention:\ This e-mail message is privileged and confid...{{dropped:9}}