Regex search help

[nangrosso]

I was asked to " update a search to append a final ' | regex PatternStringMatch="[A-Z]" query that will look for anything in that field that has both a letter and a number. Any thoughts?

[ITWhisperer]

| regex PatternStringMatch="\w"

[nangrosso]

Thanks for the response but I ran the search it gave me nothing. Any idea what the "W" represents 

[ITWhisperer]

backslash lower case w means numbers and letters. upper case letters means not numbers and letters. So, the regex will keep events where the field has letters or numbers. Is this not what you wanted?

[yuanliu · Accepted solution]

The OP ask is "has both a letter and a number" (underline is mine).  "\w" will match any single character that is not a "punctuation", so "a" (no number), "1" (no letter), "___" (no letter or number), "a_b_c_", "1_2_3_", etc., will all match.  The following will match "both a letter and a number":

| regex PatternStringMatch="[a-zA-Z].*\d|\d.*[a-zA-Z]"

---

[nangrosso]

Thanks for the detailed explanation 

[ITWhisperer]

You are right, the specification is ambiguous - \w with match both a letter and a number (and non-punctuation).