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?
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]"
| regex PatternStringMatch="\w"
Thanks for the response but I ran the search it gave me nothing. Any idea what the "W" represents
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?
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]"
Thanks for the detailed explanation
You are right, the specification is ambiguous - \w with match both a letter and a number (and non-punctuation).