Skip to Content
Former Member
Apr 04, 2006 at 12:55 AM

Function syntax for validation expression


Does anyone know where I can find the syntax for the Functions that are available in the Validation Expression dialog box in the Validations tab of Data Manager?

I could not find anything in the The only hint is that they are Excel like. One function in MDM is FIND, but the syntax in Excel is different than the syntax in MDM.

EXCEL Syntax



- Find_text is the text you want to find.

- Within_text is the text containing the text you want to find.

- Start_num specifies the character at which to start the search.

In MDM, it's


FIND(within_text,find_text)<optional qualifier>

e.g. FIND(FieldA,"A")=2

this states: Find the string "A" in FieldA and test if it was found in position 2 (returns True or False)

Anyway, if you know where I can find the syntax for all the functions - that would be very helpful and appreciated and would save a lot of trial and error time.

with best regards,