Is there a way to get a locale-correct orderby()?

[agladysh]

Problem:

çilek
erik
şeftali
armut
üzüm

By default, orderby() gives incorrect (for tr-TR locale) sorting order:

aq.fromCSV(csv, { header: false }).orderby('col1').toCSV()

armut
erik
çilek
üzüm
şeftali

Correct order would be:

armut
çilek
erik
şeftali
üzüm

One can achieve that by using String.localeCompare() in the comparator:

(lhs, rhs) => lhs.localeCompare(rhs, 'tr-TR');

Is there a way to feed this comparator to the Arquero somehow?

[jheer]

There is not a mechanism for this at present. Currently Arquero relies on standard JS comparison operators. I'll open a feature request issue for this.

[jheer]

Arquero version 7.1.0 now includes a collate helper function to support custom string orders. You can use it in your example above like so:

aq.fromCSV(csv, { header: false }).orderby(aq.collate('col1', 'tr-TR')).toCSV()

The collate method accepts either arguments compatible with the Intl.Collator constructor (such as a locale string) or a two-argument custom comparator function.

[agladysh]

Wow! Thank you! This helps a lot!