Difference between revisions of "Manuals/calci/SUBSTRINGCOUNT"

(Created page with "<div style="font-size:30px">'''SUBSTRINGCOUNT (FindStringIncRegExp,InString,IgnoreCase) '''</div><br/> *<math>FindStringIncRegExp</math> and <math>InString</math> are any stri...")
 
 
(One intermediate revision by the same user not shown)
Line 11: Line 11:
 
==Examples==
 
==Examples==
  
 +
==Related Videos==
 +
 +
{{#ev:youtube|v=Fjt6oNp-FX8|280|center|String}}
  
 
==See Also==
 
==See Also==
Line 19: Line 22:
  
 
==References==
 
==References==
[http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/StringFunctions/SubStringCount.htm]
+
[http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/StringFunctions/SubStringCount.htm Sub String]
  
 
*[[Z_API_Functions | List of Main Z Functions]]
 
*[[Z_API_Functions | List of Main Z Functions]]
 
*[[ Z3 |  Z3 home ]]
 
*[[ Z3 |  Z3 home ]]

Latest revision as of 13:12, 4 April 2019

SUBSTRINGCOUNT (FindStringIncRegExp,InString,IgnoreCase)


  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle FindStringIncRegExp} and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle InString} are any string.

Description

  • This function Counts the number of substring occurrences.
  • In Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle SUBSTRINGCOUNT (FindStringIncRegExp,InString,IgnoreCase)} ,Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle FindStringIncRegExp} is any string or any regular expression.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle InString} is a string which may occur one or more times within the input string text.
  • This function returns the number of occurrences of the specified substring in the input string text.
  • If there is no match, 0 is returned.

Examples

Related Videos

String

See Also


References

Sub String