Returns true if text value {0} starts with text value {1}, false otherwise. {0}: A text value which is to be searched {1}: ...

Returns true if text value {0} starts with text value {1}, false otherwise.
      
  • {0}: A text value which is to be searched
  • {1}: A text value which is the substring to be searched for in {1}
  • {2}: [Optional] A Comparer used for controlling the comparison. For example, Comparer.OrdinalIgnoreCase may be used to perform case insensitive searches
{2} is a Comparer 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 comparison
  • Comparer.OrdinalIgnoreCase: Used to perform an exact ordinal case-insensitive comparison
  • Comparer.FromCulture: Used to perform a culture aware comparison