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!

returns a boolean result, answering the question

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

BELGIAN payment reference system

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.

returns the type of a data ("Number, TimeStamp, Date, Time, Container, or Text )

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)

allow user to input dates faster

Allows the user to input time data in a more convenient manner, without annoying data type validation errors.

Filters a text with ASCII, Extended ASCII, or UTF-8 table. Useful to get rid of unexpected characters copied from some crappy word processors like MS Word