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 thisREGEX_Match([YourFieldName], "^(PR|SD)\d{7,8}$")mark done if solved.
@Raj
i tried your solution but its not pulling anything when i used this as a filter
@Cherub7210 can you share some sample data of what works and what doesnt
@Cherub7210 share some sample data.
@Cherub7210 The following should work in a filter formula.
thank you all for your inputs and i was able to solve this using a different approach
