Sorting Order

[JDong]

Hi Team,

Sort Column

ANA

ARAX

Armani

Basics

C and A

Capital

Peak

Pentagon

Porvai

QUEST

Quantum

RFE

REALISTIC

Savigny

SIGNAL

The Capitol

TLD Immov

TPGIT

Tisha

Union Jack

DC Values

Wealthny

Westen Part

WeWoke

alstrivia

pwr

I want to sort all the records shown in ascending order. Irrespective of it beign small or capital. Any idea here please since the sort tool options are not helping.

Thanks

[AngelosPachis]

Hi @JDong ,

What you can do is use a formula tool to create a new field which contains the lowercase version of that initial column.

Then you can use a sort tool to to sort based on that new field in an ascending order, and then drop it with a select tool

Hope that helps,

Angelos

[JDong]

Thanks @AngelosPachis this is great...is there a way to make only first letter in capitals and rest in small ?

[Qiu · Accepted solution]

@JDong 

I think his continent is night time now😁

Make a minor change based on @AngelosPachis  work.

[AngelosPachis]

Yes, @JDong 

Try the Titlecase function instead of the lowercase; that should do it

[echuong1]

Another option is to use the data cleansing! You can modify to title case at the bottom.

[danilang]

Hi @JDong 

Check the "Use Dictionary Order"  option in the sort Tool

Results are sorted irrespective of letter case

Dan

[JDong]

Thanks to all of you !

The solution accepted works for the use case. The dictionary order did not work on my dataset.

[danilang]

Hi @JDong 

Can you post a sample of your actual input data?  

Dan

[JDong]

Hi @danilang 

Thanks for the kind help !

The data is kind of sensitive so need time to extract and format the same. For some reason the lower case word is always shown at the bottom of the result even when we set the dictionary order to be active.