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
Solved
Case Insensitive Sort
Best answer by howard_l
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'
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+51- Celebrity
- 2077 replies
Hi @jimo you can use BulkAttributeRenamer and choose lower or upper case.
Thanks
- 7843 replies
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
Is there a way to make the sort and keep the case of the values in the attribute?
+1Make 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'
- 7843 replies
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.
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'
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.
- 7843 replies
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.