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
Last modified 3yr ago
Copy link
Contents
Comparer.Ordinal
Description
Category
Examples