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.Ordinal
Comparer.Ordinal
Returns a comparer function which uses Ordinal rules to compare values.
function (optional
x
as nullable any, optional
y
as nullable any) as number
Description
Returns a comparer function which uses Ordinal rules to compare the provided values
x
and
y
.
Category
Comparer
Examples
Using Ordinal rules, compare if "encyclop?dia" and "encyclopaedia" are equivalent. Note these are equivalent using
Comparer.FromCulture("en-us")
.
1
Comparer.Equals(Comparer.Ordinal, "encyclop?dia", "encyclopaedia")
Copied!
false
Previous
Comparer.FromCulture
Next
Comparer.OrdinalIgnoreCase
Copy link
Contents
Comparer.Ordinal
Description
Category
Examples