NthFieldB Function

Returns a field from a row of data. NthFieldB is identical to NthField except that it treats the source data as binary data.

Syntax
result = NthFieldB( source, separator, fieldNumber )
result = stringVariable.NthFieldB( separator, fieldNumber )

Parameters
source | String | The fields of data.
separator | String | The character that separates the columns of data.
fieldNumber | Integer | The column number of the field of data desired. The first field is numbered 1.

Return Value
Result | String | The field value desired.

# Notes

The first field is numbered 1.

The NthFieldB 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. NthFieldB is not case-sensitive.

# Examples

## This example returns "Smith"

Dim field As String
field=NthFieldB("Dan*Smith*11/22/69*5125554323*Male","*",2)

.

Using the second syntax:

Dim s,field As String
s="Dan*Smith*11/22/69*5125554323*Male"
field=s.NthFieldB("*",2)
MsgBox field

See also the example that illustrates how to populate a PopupMenu control.

# See Also

CountFieldsB, NthField, SplitB functions.