regex to find a word in a sentence

Question

I have a string like following:

CREATE GLOBAL TEMPORARY TABLE some_temp_table_name

OR

CREATE GLOBAL TEMPORARY TABLE some_temp_table_name something else

with the regex I want to strip out whatever is in bold letters.

I have the following regex

([a-z].*[\s]*)

what should I change in the regex?

Answer 1

Try this:

([A-Z\s]+)[a-z_]+\s?([a-z\s]+)

In Groovy you would do something like this:

String clean 
    = yourString.replaceAll("([A-Z\s]+)[a-z_]+\s?([a-z\s]+)", "$1$2");

Answer 2

try? :

([a-zA-Z\s]+TABLE)\s\b[a-zA-Z_]+\b(.*)

Answer 3

If my goal would be to extract lowcase parts I'd do the following in ruby:

'CREATE GLOBAL TEMPORARY TABLE some_temp_table_name '.gsub(/[A-Z]/,'').gsub(/[\s]{2,}/, ' ').strip

Answer 4

Based on the 2 cases you provided, the following should work in Groovy:

def s1 = "CREATE GLOBAL TEMPORARY TABLE some_temp_table_name"
def s2 = "CREATE GLOBAL TEMPORARY TABLE some_temp_table_name something else"

def t1 = s1 =~ /CREATE GLOBAL TEMPORARY TABLE (\w+)/ 
def t2 = s2 =~ /CREATE GLOBAL TEMPORARY TABLE (\w+)/ 

assert "some_temp_table_name" == t1[0][1]
assert "some_temp_table_name" == t2[0][1]