Function NthFieldMBS
NthFieldMBS(text as string, delimiter as string, fieldNumber as integer) as string
Version: 1.0
Returns a field from a row of data. The first field is numbered 1.
The NthField function returns the field value from the source that precedes the fieldNumber occurrence of the separator in the source. If fieldNumber is out of bounds, an empty string is returned. NthField is not case-sensitive.
If the text is empty, the delimiter is empty of the index is negative, an empty string is returned.
Example queries:
select NthFieldMBS("Hello;World",";",1)
select NthFieldMBS("Hello;World",";",2)
select NthFieldMBS("Hello;World",";",3)
Back to function list.