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?
@Cherub7210
use this
REGEX_Match([YourFieldName], "^(PR|SD)\d{7,8}$")
mark done if solved.
@Cherub7210 can you share some sample data of what works and what doesnt
@Cherub7210
share some sample data.
thank you all for your inputs and i was able to solve this using a different approach :)