R reading csv file i want to only one column with that row end with specific string value

Question

** above image showing sample data list, so i want to get only record that content specific keyword end like (contact); on that row. **

data <- read.csv("csv.csv", sep = ',')

# Get the max salary from data frame.
Piname <- data$col_NAME
print(Piname)
poname <- Piname[str_detect(Piname,"(end_string);")]
print(poname)

#summary(warnings())

tail(warnings(), 50)

Please show a small reproducible example. Try with `str_detect(Piname,fixed("(end_string);)")` — akrun, Dec 08 '19 at 16:17
BRYAN, ROBERT M; MCCULLOUGH, LOUISE D. (contact); this the example data line i want only end with (contact); — Mr Coder, Dec 08 '19 at 16:30
here it shows anywhere in content (contact); but i want to only end with — Mr Coder, Dec 08 '19 at 16:35

akrun · Accepted Answer · 2019-12-08T16:40:35.047

1

We can either escape the () \$contact\$;$ and use it as pattern

Piname[str_detect(Piname, "\\(contact\\);$")]

as by default, the ( or ) would be recognized as metacharacters to capture the characters as a group. The $ is a metacharacter to signify the end of string

edited Dec 08 '19 at 16:40

answered Dec 08 '19 at 16:34

akrun

874,273
37
540
662

Piname[str_detect(Piname, fixed("(contact);$"))] for this, i am not getting any data output – Mr Coder Dec 08 '19 at 16:46
@CoderS I removed the `fixed` as you want to use regex `$` please check my update – akrun Dec 08 '19 at 16:48

R reading csv file i want to only one column with that row end with specific string value

1 Answers1