Power Query
Search…
published
Introduction
Accessing Data
Action
Binary
Binary Formats
Combiner
Comparer
Comparer.Equals
Comparer.FromCulture
Comparer.Ordinal
Comparer.OrdinalIgnoreCase
Cube
Date
Date Time
Date Time Zone
Diagnostics
Duration
Error
Expression
Function
Lines
List
Logical
Metadata
Number
Record
Replacer
Splitter
Table
Text
Time
Type
Uri
Values
Powered By GitBook
Comparer.FromCulture

Comparer.FromCulture

Returns a comparer function given the culture and a logical value for case sensitivity for the comparison.
function (culture as text, optional ignoreCase as nullable any) as function

Description

Returns a comparer function given the culture and a logical value ignoreCase for case sensitivity for the comparison. The default value for ignoreCase is false. The value for culture are well known text representations of locales used in the .NET framework.

Category

Comparer

Examples

Compare "a" and "A" using "en-US" locale to determine if the values are equal.
1
Comparer.FromCulture("en-us")("a", "A")
Copied!
-1
Compare "a" and "A" using "en-US" locale ignoring the case to determine if the values are equal.
1
Comparer.FromCulture("en-us", true)("a", "A")
Copied!
0
Previous
Comparer.Equals
Next
Comparer.Ordinal
Copy link
Contents
Comparer.FromCulture
Description
Category
Examples