AnsweredAssumed Answered

Validation Calculation...

Question asked by techxp on Dec 30, 2013
Latest reply on Dec 31, 2013 by erolst

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.

 

Kind Regards

Michael Mayrhofer

Pack Safari

Outcomes