Skip to main content
  • EN

The Sorter does not appear to have an option for case-insensitive sort. Is it possible?

I am using FME Desktop 2016.1.3.1

Hi @jimo you can use BulkAttributeRenamer and choose lower or upper case.

Thanks

Hi @jimo, there is no option to perform case-insensitive sorting. As a workaround, consider uniforming all attribute values to one of UPPER CASE or lower case, with the StringCaseChanger, @UpperCase function or @LowerCase function.

Hi @jimo you can use BulkAttributeRenamer and choose lower or upper case.

Thanks

I know that you can use other transformers to make everything upper case or lower case and sort that way, but the problem is, this attribute represents a list of FMW scripts that will appear in a select box, and it is really important that the case of the FMW scripts remains true.

 

 

Is there a way to make the sort and keep the case of the values in the attribute?

 

 

Make a COPY of your original field (eg using AttributeManager).

Change case of data in new field to UpperCase.

Sort on this new UpperCase field.

................

Hope this helps

Howard L'

I think the NaturalSorter will give you the desired result.

Hi @jimo, there is no option to perform case-insensitive sorting. As a workaround, consider uniforming all attribute values to one of UPPER CASE or lower case, with the StringCaseChanger, @UpperCase function or @LowerCase function.

Alternatively, the InilineQuerier with this SQL statement could also be used to sort the features in case-insensitive.

 

select * from my_table order by upper(key_attribute)

 

Make a COPY of your original field (eg using AttributeManager).

Change case of data in new field to UpperCase.

Sort on this new UpperCase field.

................

Hope this helps

Howard L'

I think this answer makes the most sense. Just another field, change the case in that field, then sort by that field.

 

Thanks

 

 

Hi @jimo, there is no option to perform case-insensitive sorting. As a workaround, consider uniforming all attribute values to one of UPPER CASE or lower case, with the StringCaseChanger, @UpperCase function or @LowerCase function.

This attribute is coming from a csv file, though, not from a database.

 

 

Hi @jimo, there is no option to perform case-insensitive sorting. As a workaround, consider uniforming all attribute values to one of UPPER CASE or lower case, with the StringCaseChanger, @UpperCase function or @LowerCase function.

No problem. The InlineQuerier works regardless of what the source format is. See the Help to learn more.

 

Reply


Community Stats

30,186
Posts
114,572
Replies
37,849
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.