I am searching a column to find data that matches "P****" where those four addition characters could be numbers or letters. Currently, I have
ELSEIF regex_match([Prefix], 'P\d{4}.*') then
However, I believe this only searches for numbers.
How can I search for both letters and numbers? The word is usually "[letter][letter][letter][number][number]".
Solved! Go to Solution.
\w will match any word character, so both numbers and letters:
.{4} would be any four characters and [0-9A-Za-z]{4} would be any combination of exactly 4 numbers or letters.
User | Count |
---|---|
91 | |
79 | |
62 | |
36 | |
36 |