CODEWITHSUNDEEP
google-sheetsstring-comparison
Orange
Orange

Reputation: 547

Google Sheets strings comparator

Could anyone tell what exact strings comparing algorithm is used in Google Sheets?

I try to use an array of data sorted by Google Sheets and seems that it's not usable for binary search. For example, Google Sheets thinks that

0(48) > |(124)

-(45) > _(95)

and so on.

Thanks in advance!

Upvotes: 3

Views: 243

Answers (1)

Orange
Orange

Reputation: 547

The problem is solved. I had to create a map of ASCII -> Google Sheet indices and apply it in my own comparator. Thanks to @I'-'I for sharing "possible duplicate" to Google Sheets character sort order

Upvotes: 3

Related Questions