0

I had a database with the following column names (each one correspond to an observation of an individual in different years, i.e. year 1, year 2):

Session <- c("Evidims_01_001_1", "Evidims_01_001_2", "Evidims_01_001_3", "Evidims_01_002_1", "Evidims_01_002_2", "Evidims_01_003_1", "Evidims_01_003_2" "Evidims_01_003_3", "Evidims_01_003_4", "Evidims_01_004_1")

My idea is to create a wide table, but first I want to delete the strings: "Evidims_0x_00x_y" and just keep the last number in each of the names, ie "1", "2".

Thanks in advance!

Improve this question

4 Answers 4

Reset to default
0

Do you mean like this?

sub('.*_', '', Session)
#[1] "1" "2" "3" "1" "2" "1" "2" "3" "4" "1"
Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

you save me! Thanks!
0

This could help too:

regmatches(Session, regexpr("\\d+$", Session, perl = TRUE))

[1] "1" "2" "3" "1" "2" "1" "2" "3" "4" "1"
Improve this answer

Comments

0

You could also use:

sub(".*(\\d+)$", "\\1", Session)
Improve this answer

Comments

0

We can use trimws from base R

trimws(Session, whitespace = '.*_')
[1] "1" "2" "3" "1" "2" "1" "2" "3" "4" "1"
Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.