Splitbeforereadingbasicsyntaxcrystalsyntax

Splits the input string at the given delimiter.

Note: i-net Clear Reports doesn't support array types as return values for functions. So you can't directly return the result of the Split function.

Usage:

Split( x )
Split( x, y )
Split( x, y, z )
Split( x, y, z, w )

Parameters:

x	The InputString that is to be split into substrings by the delimiters.
y	The delimiter for the split [OPTIONAL, default is " "]
z	Number which decides how many parts of the string are returned, -1 if all [OPTIONAL, default is -1]
w	This decides whether to compare case-sensitive(0) or not (1) [OPTIONAL, default is 0]

Returns:

Returns an array with the split strings

Examples:

Crystal

stringVar array x;
x := Split("This is a sentence without any meaning");
x[1];
-> Returns "This" of the array ["This","is","a","sentence","without","any","meaning"].

stringVar array x;
x := Split("This is a sentence without any meaning", "a"); \
x[1];
-> Returns "This is " of the array of the array ["This is ","sentence without","ny me","ning"].

stringVar array x;
x := Split("This is a sentence without any meaning", " ",-1) \
x[1];
-> Returns "This" of the array ["This","is","a","sentence","without","any","meaning"]

Basic

dim x(100) as string;\ x = Split("This is a sentence without any meaning"," ",3)\
formula=x(1);
-> Returns "This" of the array ["This","is","a"].

dim x(100) as string;\ x := Split("This is a sentence without any meaning"," ",3) \
formula=x(1);\ -> Returns "This" of the array ["This","is","a"].