Guidance Reg_Ex Match

[Cherub7210]

i need to test if the string starts with a PR or SD and 7 to 8 digits long. Could you give me inputs how i  should  this in formula tool?

[Raj]

@Cherub7210 
use this
REGEX_Match([YourFieldName], "^(PR|SD)\d{7,8}$")

mark done if solved.

[Cherub7210]

@Raj  

i tried your solution but its not pulling anything when i used this as a filter 

[Deano478]

@Cherub7210 can you share some sample data of what works and what doesnt

[Raj]

@Cherub7210 
share some sample data.

[cjaneczko]

@Cherub7210 The following should work in a filter formula.

[Cherub7210]

thank you all for your inputs and i was able to solve this using a different approach :)