LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Gaetan.Patry

I am using the SORT node to sequence names that have typos, including being written in lower and upper case.
I realized that the SORT node first sorts names with upper case letters and then lower case letters.
For example, the names Love1, LOVE2, Lava1, LAVA2 will be sorted, by the SORT Node, as LAVA2, LOVE2, Lava1, Love1.
What I was expecting is more like Lava1, LAVA2, Love1, LOVE2 , which is what I get when I use the AZ Sort button in the BRDViewer.

Is there an option or a way to force the SORT Node to behave the same as the SORT Button in BRDViewere and NOT be case sensitive.

Thanks,
Ga�tan

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

In the sort node, simply put

Field.toUpper()

and the records will be sorted based upon that - it won't change the data, just the criteria for the sort order

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Gaetan.Patry

Great! tested and working!
Thanks for the quick reply