SubField - script and chart function

In its three-parameter version, this function returns a given substring from a larger string s with delimiter 'delimiter'. Index is an optional integer denoting which of the substrings should be returned. If index is omitted when subfield is used in a field expression in a LOAD statement, the subfield function will cause the LOAD statement to automatically generate one full record of input data for each sub-string that can be found in s.

In its two-parameter version, the subfield function generates one record for each substring that can be taken from a larger string s with the delimiter 'delimiter'. If several subfield functions are used in the same LOAD statement, the Cartesian product of all combinations will be generated.

Syntax:  

SubField ( s, 'delimiter' [ , index ] )

 

Examples and results:

Example	Result
SubField(S, ';' ,2)	Returns 'cde' if S is 'abc;cde;efg'
SubField(S, ';' ,1)	Returns NULL if S is an empty string
SubField(S, ';' ,1)	Returns an empty string if S is ';'