Sorting with special characters

[Anonymous]

These are two charts

In order to make the dimensions in center alignment. i have inserted dots (.) at both front and back. Because of this it couldn't able to sort

Now i want to sort it in ascending order..

Help me in finding this.

[tripatirao]

Dear Kishore,

Do you want sort the the value of Global Session or want to sort chart value.

Can you please elaborate you requirement.

Best Regards

Tripati

[tresesco · Accepted solution]

Try sort expression like:

=rank(purgechar(YourField, '.'))

[Anonymous]

can you please tell, how it is getting sorted with rank function?

[tresesco]

Have you tried it? Is it not working?     Rank() here is ranking the text values like in Text Sort.

[Anonymous]

yes. i tried. and its working fine.. Thanks for your help

[Lucky1]

Hi I have same scenario but i have extra scenario like 

for my column i have ._ together like US.IL_IDFP

i want output like 

US.CBOE

US.CME

US.DTCC

US.FINRA

US.FR

US.MGE

US.NF

US.OC

US.IL_IDFP

US-IL.IDFPf