extracts the end of a text, based on a search string and an occurrence number
Use in reevaluating auto-enter calculations to allow the user to input something in the field without it to re-evaluate and erase the user entered value. No need to hard code the field name anymore!
extracts the beginning of a text, based on a search string and an occurrence number
extracts the middle of a text in between delimiters, based on a search strings and an occurrence numbers
extracts the middle of a text in between delimiters, based on a search strings and an occurrence numbers
Finds consecutive items in a list of values and returns the first of each group. Designed to find a free time slice in an agenda, for example.
Formats and translates date according to a pattern in one of the supported languages.
returns the list of all enclosing objects of a layout object, in reverse order. (smallest first)
Converts : - an Excel column header into a number (BR -> 70) - a number into an Excel column header (70 -> BR) Limited to ZZ (702)
Allows the user to input time data in a more convenient manner, without annoying data type validation errors.