AnsweredAssumed Answered

Conditional Formatting Field Verification

Question asked by on Aug 19, 2014
Latest reply on Aug 21, 2014 by


Conditional Formatting Field Verification



     I'm trying to create a conditional formatting change in my records based on extra space within my field data.  

     I've got a field that I am extracting from another system, that various people are entering the data into.  Occasionally they will enter a space before or after a 9 digit serial number they either paste into or manually enter into the field.  It is very difficult to locate the space especially if it occurs after the 9 digits.  When I extract the data and import it into my Filemaker verification template, I want fields with the extra space to highlight with a color, indicating the error within the field. 

     I know how to FIND the error using " " , but have not been able to figure out how to create a Conditional Format calculation to identify it. 

     Any help is appreciated.