[R] Extract letters from a column
SH
emptican at gmail.com
Wed Mar 13 15:21:18 CET 2013
What I want to do is to extrac three letters from first and last name
and to combine them to make another column 'abb'. The column 'abb' is
to be a my final product. I can make column 'abb' using 'paste'
function once I have two parts from the first column 'name'.
Thanks,
Steve
On Wed, Mar 13, 2013 at 10:17 AM, Jorge I Velez
<jorgeivanvelez at gmail.com> wrote:
> Try
>
> substr(tempdf$abb 4, 6)
>
> --JIV
>
>
>
> On Thu, Mar 14, 2013 at 1:15 AM, SH <emptican at gmail.com> wrote:
>>
>> 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