Text.Lower
A text in small letters.
Group: Text and characters. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
Text.Lower(text as nullable text, optional culture as nullable text) as nullable text| Parameter | Type | Description |
|---|---|---|
text | nullable text | The text to work on; null gives null. |
culture | nullable text optional | A culture's name, such as "tr-TR", for that language's own letter rules; left out, the query's culture. A name no culture has is an error. |
Returns
nullable text. The text in lower case; null when the text is null.
Remarks
- Letters of every alphabet change as in Power Query: Æ Ø Å become æ ø å, Ł becomes ł.
- In Turkish and Azerbaijani (tr-TR, az) a capital I becomes the dotless ı, and İ becomes i; elsewhere I becomes i. Left out, the culture is the query's (
Culture.Current): the model's Locale for import, else the model's own culture, else en-US. The examples here run in en-US.
Examples
A city name
Text.Lower("OSLO")"oslo"Nordic letters
Text.Lower("ÆRLIG ØL PÅ BRYGGEN")"ærlig øl på bryggen"Turkish
Text.Lower("İSTANBUL", "tr-TR")"istanbul"