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.