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.