From Xojo Documentation
|You are currently browsing the old Xojo documentation site. Please visit the new Xojo documentation site!|
| This item was deprecated in version 2019r2.
Please use MemoryBlock as a replacement.
Returns the number of values (fields) in the string passed that are separated by the separator string passed.
result = CountFieldsB(source, separator)
|result||Integer||The number of values in source that are separated by separator.|
|source||String||The original string.|
|separator||String||The character or characters that separates the values in source. Separator can be of any length.|
The CountFieldsB function is useful for reading columns of data from a text file where the columns (fields) are delimited with a specific character or characters.
If the separator is not found within source, CountFieldsB returns 1. If source is null, CountFieldsB returns zero.
The code below returns 5.
Dim s As String
s = "Dan*Smith*11/22/69*5125554323*Male"
count = CountFieldsB(s, "*")
The following code returns three because it counts the null "field" after the (unnecessary) final field delimiter.
See also the code that illustrates how to populate a PopupMenu control.