[R] Extract letters from a column
SH
emptican at gmail.com
Wed Mar 13 15:15:31 CET 2013
Dear Jorge,
I gave me this result (below) since it defines starting from the forth
letter and ending 6th letter from the first element.
> substr(tempdf$name, 4, 6)
[1] " Cr" "ad " "old"
I would like to have letters from first and second elements if possible.
Thanks for replying,
Steve
On Wed, Mar 13, 2013 at 10:10 AM, Jorge I Velez
<jorgeivanvelez at gmail.com> wrote:
> Dear SH,
>
> Hmmm... what about
>
> substr(tempdf$name, 4, 6))
>
> ?
>
> HTH,
> Jorge.-
>
>
> On Thu, Mar 14, 2013 at 1:06 AM, SH <emptican at gmail.com> wrote:
>>
>> Dear list:
>>
>> I would like to extract three letters from first and second elements
>> in one column and make a new column.
>>
>> For example below,
>>
>> > tempdf = read.table("clipboard", header=T, sep='\t')
>> > tempdf
>> name var1 var2 abb
>> 1 Tom Cruiser 1 6 TomCru
>> 2 Bread Pett 2 5 BrePet
>> 3 Arnold Schwiezer 3 7 ArnSch
>> > (p1 = substr(tempdf$name, 1, 3))
>> [1] "Tom" "Bre" "Arn"
>>
>> I was able to extract three letters from first name, however, I don't
>> know how to extract three letters from last name (i.e., 'Cru', 'Pet',
>> and 'Sch'). Can anyone give me a suggestion? Many thanks in advance.
>>
>> Best,
>>
>> Steve
>>
>> ______________________________________________
>> 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.
>
>
More information about the R-help
mailing list