Looking for formula to identify where a field begins D followed by two numbers

[Creanstar]

Hi,



I am struggling with a formula to tell me a field is true when it begins with D followed by two numbers - can anyone help?

[recyan]

Till someone comes along, check out LEFT(), MID(), IIF(), ISNUMERIC(),

Thanks

[ItsMe]

I would use VBA to assign the value to a string variable. With that, you can evaluate the string using InStr() and some of the functions listed in post #2.

[John_G]

Try something like this:

Assume you have copied the data to a variable called str, for simplicity, and you have a boolean variable called IsValid:

IsValid = left(str,1) = "D" AND isnumeric(mid(str,2,1)) AND isnumeric(mid(str,3,1))

John