Problem with the simplest rex

[rachelneal]

I have several error logs that have a similar format:

Cannot set Single Use Prices on Single Room Standard Room (
Cannot set Single Use Prices on Single Room Standard Suite (
Cannot set Single Use Prices on Single Room Executive King Room (

The rex that I am attempting to use only returns a table of blank lines.

"Cannot set Single Use Prices on Single Room " |rex "(?<Error>\w+?)\(" | table Error

I've tried \w \w+ \w+? \. \.+ \.+?

Any suggestions?

[rachelneal · Accepted solution]

Thanks everyone. I ended up with rex "\"(?.+?(\d+?)).+?\'(?\d+?)\'.+?\'(?\d+?)\'" after getting rex "\"(?.+?(" to work. Woohoo!

[hjwang]

try

| rex "(?<Error>[^\r\n\(]+)\("

[Lowell]

Is there a space between the last word and the "(". If so, your regex isn't going to match. Try:

| rex "(?\w+)\s+("

[Lowell]

That's true. It depends on what you are looking for. rachelneal, if you would provided additional details in your question (use the "edit" link below you question), then a more suitable regex could be suggested. Specifically, note what strings you would like to extract from the samples given.

[gkanapathy]

Also, \w will not match spaces, so all you're going to get is the word "Room" or "Suite".