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 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
• asUniqueList - aggregates the unique 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
• asExprList_with_null - is the AsExprList variant that includes null values
• AsItemList - aggregates string values to a new string data item, comma delimited
• asItemList_with_null - is the AsItemList variant that includes null values
• 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
• to_utf - convert a string from system encoding to UTF-8
• AsItemName - converts a string to a valid GeoDMS Tree item name

• UrlEncode - encode strings for safe use in URLs
• UrlDecode - decode URL-encoded strings
• HtmlEncode - encode strings for safe use in HTML
• HtmlDecode - decode HTML-encoded strings

• split_piped_string - split strings by pipe character
• split_multi_linestring