How to replace pattern of string in r

Question

I have a dataframe column which have pattern like

   | NA

I want to replace this and text after this with blank space.

  | NA | 0 | 4

So above string should be replaced by blank space. I used following code.

  df$string <- gsub("| NA" , "",df$string)

But its nit workinh for the string after this pattern.

score 1 · Accepted Answer · answered Feb 03 '17 at 07:54

1

Use this:

df$string <- gsub("\\| NA.*$" , "", df$string)

The pipe | symbol is a regex metacharacter (alternation). So it needs to be escaped in order to match it literally.

The regex I used \\| NA.*$ will match your desired pattern and anything following it to the end of the line, and will replace it with empty string.

answered Feb 03 '17 at 07:54

Tim Biegeleisen

I have other pattern like | 0 | Recom : 0 | TGT : 0 Other. How can I remove above pattern till 'Other' – Neil Feb 03 '17 at 09:49
`gsub(".*Other", "Other", df$string)` – Tim Biegeleisen Feb 03 '17 at 10:11
I have string before | 0 | but that string is not same in all rows. So how can I remove above pattern between 'dynamic string' and 'Other' – Neil Feb 03 '17 at 10:46
It's not clear what you want now. You should open a new question. – Tim Biegeleisen Feb 03 '17 at 10:56

1 Answers1