Good day all,
I am currently in the midst of attempting to create a validation calculation for a field that has to include in series two numbers, five characters and five numbers e.g. 14CHAETO20131.
If anyone has any helpful information I would greatly appreciate your input. I have attempted to use :
"Filter ( MiddleValues (Testing::TourNumber;1 ; 2 ) ; "0123456789" ) and Filter ( MiddleValues (Testing::TourNumber;3 ; 6 ) ; "ABCDEFGHIJKLMNOPQRSTVWXYZ" ) "
However I suspect that the two Filters cause a conflict in the calculation causing it to fail.