String

 See Also  Expression Field Programmed Field

String: CTOD Attempts to create a new discrete field, usually by having applied a filter to a continuous string, integer or double. Purpose Use this function to: Create a discrete field from a continuous field Create a copy of a continuou...

String: DateFromString(A,B) Produce a date field from a date stored as string Purpose Use this function to: Convert Dates loaded as strings into Date fields Create Date fields after loading unknown date columns as strings for inspection a...

String: ICAST Extract numeric data contained in a string and store as a numeric integer Converts a DISCRETE or CONTINUOUS STRING field into an INTEGER field. The string must be an exact integer or it will be cast as NULL. Purpose Use thi...

General: [] Extract numeric data contained in a string or integer and store as a longinteger Purpose Use this function to: Cast data from integer to longinteger (to support creation of joins) Cast data loaded as string to longinteger&nbs...

General: LOWER(A) Forces all characters in a string to be lowercase. Purpose Use this function to: transform a string to lowercase characters Return Value Return Value: "all lower case string, even with other characters" Par...

String: RIGHTOF Extracts all characters to the right of the first occurrence of defined character. Purpose Use this function to: Extract a sub-string from another string Find text to the right of a specified string Return Value M...