SPLIT splits a text according to the format into several parts (numeric or string) and assigns these parts to one or more variables. The execution of SPLIT is halted, when the first non-matching part is encountered. SPLIT returns the number of successfully read values as integer.
SPLIT (string, format, variable1 [, variable2, ..., variablen])
string (string): the string which should be split.
format: any combination of constant strings, %s and %n -s. Parts in the string must fit the constant strings, %s identifies any string value, which is delimited by spaces or tabs, while %n identifies any numeric value.
variablei (string or decimal, depends on format): the names of the variable, into which the split strings are stored.
Decimal numbers must be separated by ".", otherwise only the places before the decimal point are considered.
siehe auch SPLIT