how to sort the listing have value with string and text

[chipmunkG]

Hi,

I have issue on sort listing that have value with string and  text for example;

1.0m, 2.0m, 4.0m,8.0m, 10.0 m, others,218k, 512k.

I want the listing to sort like 

218k

512k

1.0m

2.0m

4.0m

8.0m

10.0m

others

[Anil_Babu_Samineni]

You want this in script? Or front end?

[santhiqlik]

Hi,

I would suggest to assign numeric values for that text that needs to be sorted. This can be done by creating a separate field based on the values in the text field. 

Use this numeric field in Expression in Sort tab in front end. 

[tresesco · Accepted solution]

You may try using sort by expression :

If(Index(Value, 'm'),Purgechar(Value,'m')*1000000,
	If(Index(Value, 'k'),Purgechar(Value,'k')*1000, 10e10))

 

[chipmunkG]

hi, already try this code but i got result like below which is only number display. how do i display the listing that i want.?

[chipmunkG]

front end. display like img below.

[chipmunkG]

thank you. that's great!