R extract string from data.table column

Question

This post is a continuation from R search subset string from data.table column for Capitalized words I need to add more conditions into this. A Sample Data.tabel would be

dt <- data.table(Msg= c("SOMENote: THIS_IS_IMPORTANT Rest of Message",
                       "SOMENote: THIS-IS Not Important. THIS_IS Rest of Message",
                       "SOMENote: no_string_here.. THIS_IS_IMPORTANT Rest of Message",
                       "SOMENote: THIS_HAS_110KV_Numbers. Rest of Message"))
output <- c("THIS_IS_IMPORTANT",
            "THIS_IS",
            "THIS_IS_IMPORTANT",
            "THIS_HAS_110KV_Numbers")

I want to Extract From the Message the string in the form THIS_IS_IMPORTANT which can appear anywhere in the Message after "SOMENote:".
The format also has numbers in some rows, like THIS_100L_HAS_NUMBERS.
In general, the Capitalized words with underscore between.

GKi · Accepted Answer · 2020-12-16 08:31:20Z

1

You can use sub, regexpr with regmatches to extract the hit:

y <- sub(".*:[^A-Z]*", "", x) #Remove eveything until : and not A-Z
regmatches(y, regexpr("[A-Z0-9]+_\\w*", y))
[1] "THIS_IS_IMPORTANT"      "THIS_IS"                "THIS_IS_IMPORTANT"     
[4] "THIS_HAS_110KV_Numbers"

Data:

x <- c("SOMENote: THIS_IS_IMPORTANT Rest of Message",
       "SOMENote: THIS-IS Not Important. THIS_IS Rest of Message",
       "SOMENote: no_string_here.. THIS_IS_IMPORTANT Rest of Message",
       "SOMENote: THIS_HAS_110KV_Numbers. Rest of Message")

edited Dec 16, 2020 at 8:31

answered Dec 16, 2020 at 8:18

GKi

40.1k3 gold badges36 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Ram Over a year ago

The actual Text does not have any single keyword such like THIS_. But the pattern appears after a : Thank you for the reply.

Ram Over a year ago

Yes, It is. Thank you

Ram Over a year ago

How can I get over NA in this? Some of the rows has NAs and it shows an error that the replacement has lesser number of rows. Input ` ` can't be recycled to size

GKi Over a year ago

See: How to prevent regmatches drop non matches?

Collectives™ on Stack Overflow

R extract string from data.table column

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related