I have taken Sample dataset based on your requirement like below
Create a calculation like below
You can see the calculated result below
Drag the validation to Filter and Select TRUE you will get the required O/P
Hope this helps
Plz mark this answer as correct or helpful to close the thread
Thank you Naveen, this was very helpful!
There are a ton of string functions. Here is a link:
So you want to do, for instance, a MID([Field name], 1,3) and if it's not PRJ yell at the user.
And do LEFT([Field name],6) to get the last 6 chars.
Wrap that in the INT() function. If it returns NULL, there is a non-integer character in there.