Skip to content

Latest commit

 

History

History
55 lines (35 loc) · 1.42 KB

text-startswith.md

File metadata and controls

55 lines (35 loc) · 1.42 KB
Raw
description title
Learn more about: Text.StartsWith
Text.StartsWith

Text.StartsWith

Syntax

Text.StartsWith(text as nullable text, substring as text, optional comparer as nullable function) as nullable logical

About

Returns true if text value text starts with text value substring.

  • text: A text value which is to be searched
  • substring: A text value which is the substring to be searched for in substring
  • comparer: [Optional] A Comparer used for controlling the comparison. For example, Comparer.OrdinalIgnoreCase may be used to perform case-insensitive searches

comparer 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

Example 1

Check if the text "Hello, World" starts with the text "hello".

Usage

Text.StartsWith("Hello, World", "hello")

Output

false

Example 2

Check if the text "Hello, World" starts with the text "Hello".

Usage

Text.StartsWith("Hello, World", "Hello")

Output

true