String functions
String functions operate on data items with a string value type like left or strcount
- + (concatenation) - combine two or more string values
- strlen (string length) - get the amount of characters in a string value
- strlen64 - same as strlen, but return the value as a uint64 value
- substr (sub string) - extract a part of a string value
- left - extract a part of string value starting from the left
- right - extract a part of a string value starting from the right
- strpos (string position) - get the first character position of a specific character
- strrpos (string right position) - get the first character position of a specific character, starting from the right
- strcount (string count) - count the number a of occurrences of a substring in a string value
- sort_str (sort string) - sort string values in ascending order
- quote - *add single quotes around a string value* - unquote - *remove single quotes from a string value* - dquote - *add double quotes around a string value* - undquote - *remove double quotes from a string value* - UpperCase - *convert a string value to uppercases* - LowerCase - *convert a string value to lowercases* - replace - *replace a substring within a string value* - replace_value - *replace a string value with a string value that fully matches* - repeat - *repeat a string value a specific number of times* - trim - *remove spaces before and after non-space characters in a string value* - ltrim (left trim) - *remove spaces from the left until non-space characters in a string value* - rtrim (right trim) - *remove spaces from the right until non-space characters in a string value* - asList - *aggregates string values to a new string data item with a configurable character separator* - asExprList - *aggregates string values to a new string data item, semicolon delimited and single quoted* - asItemList - *aggregates string values to a new string data item, comma delimited* - asDataString - *aggregates string values to a new string parameter, comma delimited and single quoted* - expand - *expand a placeholder* - from_utf - *convert a UTF-8 formatted string to ASCII characters* - AsItemName - *converts a string to a valid GeoDMS tree item name*
