Category: Text function
This function returns the number of instances of look_for found within text.
Argument | Type | Description |
---|---|---|
text | Text | The text value to search within for the look_for string. |
look_for | Text | The text string to search for within text. |
Return value type: Number
This function is case sensitive. To perform a case insensitive search, convert text to uppercase first using Upper(text).
Both arguments are implicitly converted to text values if required.
substringcount('one-two-three', '-') //Returns 2
substringcount('192.168.110.1', '1') //Returns 5
substringcount('Mississippi', 'S') //Returns 0 (Case-sensitive, no capital "s")
substringcount(upper('Mississippi'), 'S') //Returns 4 (Convert to uppercase first)
substringcount(1000,0) //Returns 3 (Numbers implicitly converted to text)