Function syntax for validation expression

29 Views

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 help.sap.com/saphelp_mdmgds55. 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(find_text,within_text,start_num)

- 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,

Orlando