Method # CountFieldsB ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Warning
This item was deprecated in version 2019r2. Please use `MemoryBlock` as a replacement.
## Description Returns the number of values (fields) in the string passed that are separated by the separator string passed. ## Usage *result* = **CountFieldsB**(*source*, *separator*) | Part | Type | Description | |-----------|------------------------------------|------------------------------------------------------------------------------------------------------| | 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. | ## Notes CountFieldsB is identical to `String.CountFields`, except that it treats the source string as a series of raw bytes. Use this instead of `String.CountFields` if you need the function to be case-sensitive. 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. ## Sample code The code below returns 5. ``` xojo Dim count As Integer 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. ``` xojo Dim count As Integer Dim s As String s = "Dan*Smith*" count = CountFieldsB(s, "*") ``` ## Compatibility All project types on all supported operating systems. ## See also `String.CountFields`, `MemoryBlock`, `String.SplitBytes` functions; `TextInputStream` object example