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