walkingkooka-tree-expression-function-string

A collection of ExpressionFunction(s) that operate and return string(text) results. Many of the functions follow Excel semantics.

Available functions

• ascii(number)
• char(number)
• clean(string)
• concat(string...)
• containsCaseInsensitive(string, string)
• containsCaseSensitive(string, string)
• endsWithCaseInsensitive(string, string)
• endsWithCaseSensitive(string, string)
• equalsCaseInsensitive(string, string)
• equalsCaseSensitive(string, string)
• findCaseInsensitive(string, string, number*)
• findCaseSensitive(string, string, number*)
• isNonText(value)
• isText(value)
• left(string, number)
• lowerCase(string)
• mid(string, number, number*)
• normalizeSpace(string)
• proper(string)
• repeat(string, number)
• replace(String, number, number, String)
• right(string, number)
• searchCaseInsensitive(string, string, number*)
• searchCaseSensitive(string, string, number*)
• spaceTrim(string)
• startsWithCaseInsensitive(string, string)
• startsWithCaseSensitive(string, string)
• stringLength(string)
• substitute(string, string, string, number?)
• substringAfter(string, string, number*)
• substringBefore(string, string, number*)
• t(object)
• text(object)
• textJoin(string delimiter, boolean ignoreEmpty, string text, string more-text)
• trim(string)
• trimLeft(string)
• trimRight(string)
• unicode(string)
• upperCase(string)

Many more functions are outstanding and remain TODO.