Returns the position of the specified occurrence of the text value {1} found in {0}. An optional parameter {2} may be used to specify which occurrence position to return (first occurrence by default).{3} is aComparer
which is used to control the comparison. Comparers can be used to provide case insensitive or culture and locale aware comparisons.The following built in comparers are available in the formula language:
Comparer.Ordinal
: Used to perform an exact ordinal comparisonComparer.OrdinalIgnoreCase
: Used to perform an exact ordinal case-insensitive comparison-
Comparer.FromCulture
: Used to perform a culture aware comparison
Returns the offset in list {0} of the first occurrence of a value in a list {1}. Returns -1 if no occurrence is found. An ...
Returns the parts of the input {0} as a record, containing values such as Scheme, Host, Port, Path, Query, Fragment, UserName ...
Returns the Poisson distribution. A common application of the Poisson distribution is predicting the number of events over ...
Returns the position of the first occurrence of any of the characters in the character list {0} found in the text value {1}. ...
Returns the position of the specified occurrence of the text value {1} found in {0}. An optional parameter {2} may be used ...
Returns the product of multiplying {0} by {1}. An optional {2} parameter may be specified, by default Precision.Double is ...
Returns the product of the numbers in the given {1} of the {0}. If the column does not contain number values, an exception ...
Returns the rank of a number in a column of numbers. If more than one value has the same rank, the top rank of that set of ...
Returns the rank of a number in a column of numbers. If more than one value has the same rank, the top rank of that set of ...