Syntax

Item$(text$,first,last [,delimiters$])

Description

Returns all the items between first and last within the specified formatted text list.

Comments

The Item$ function takes the following parameters:

Parameter

Description

text$

String containing the text from which a range of items is returned.

first

Integer containing the index of the first item to be returned. If first is greater than the number of items in text$, then a zero-length string is returned.

last

Integer containing the index of the last item to be returned. All of the items between first and last are returned. If last is greater than the number of items in text$, then all items from first to the end of text are returned.

delimiters$

String containing different item delimiters.

By default, items are separated by commas and end-of-lines. This can be changed by specifying different delimiters in the delimiters$ parameter.

Example

This example creates two delimited lists and extracts a range from each, then displays the result in a dialog box.

Const crlf = Chr$(13) + Chr$(10)

Sub Main()
  ilist$ = "1,2,3,4,5,6,7,8,9,10,11,12,13,14,15"
  slist$ = "1/2/3/4/5/6/7/8/9/10/11/12/13/14/15"
  list1$ = Item$(ilist$,5,12)
  list2$ = Item$(slist$,2,9,"/")
  MsgBox "The returned lists are: " & crlf & list1$ & crlf & list2$
End Sub

See Also

ItemCount (function); Line$ (function); LineCount (function); Word$ (function); WordCount (function).

I