Function NthFieldRevMBS
NthFieldRevMBS(text as string, delimiter as string, fieldNumber as integer) as string
Version: 1.2
Returns a field from a row of data. The last 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 counted back from the end. If fieldNumber is out of bounds, an empty string is returned. NthFieldRev 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 NthFieldRevMBS("Hello;World",";",1)
select NthFieldRevMBS("Hello;World",";",2)
select NthFieldRevMBS("Hello;World",";",3)
Back to function list.