Split strings: SELECTSplit("SQL Tutorial is fun!")ASSplitString; Result: {"SQL","Tutorial","is","fun!"} SELECTSplit ("red:green:yellow:blue",":",2)ASSplitString; Result: {"red","green"} Definition and Usage The Split() function splits a string into an array of strings. ...
If a limit is specified, the returned array will not be longer than the limit. The last element of the array will contain the remainder of the string, which may still have separators in it if the limit was reached.Tip: See the Java RegEx tutorial to learn about regular expressions.Syntax...
lengthOptional. Specifies the length of each array element. Default is 1 Technical Details Return Value:If length is less than 1, the str_split() function will return FALSE.If length is larger than the length of string, the entire string will be returned as the only element of the array....