LOV - Sorting

[Former Member]

Hi ,

Please let me know if u have any idea on below scenerio.

List Of Lov for Prompt Now:

Period 3 2010

Period 3 2011

Period 4 2010

Expected Sorting would be

Period 3 2010

Period 4 2010

Period 3 2011

Thanks In Advance

[Former Member · Accepted solution]

Hi,

If your field doesn't need to be in that format, I'd suggest changing it to:

2010 Period 3

2010 Period 4

2011 Period 3

This will of course sort properly.

Otherwise, I've written a post [on sorting LOVs, here|http://blog.davidg.com.au/2011/05/sorting-list-of-values-non.html] that should be useful.

Hope that helps.

[Former Member · Accepted solution]

Hi David ,

This time also i have problem like if period more than 10 right?

see below example

2010 Period 9

2010 Period 10

2011 Period 10

2010 Period 11

[Former Member · Accepted solution]

You'll need to change that last number to 09.

I'd imagine you'd use a combination of substr, right, replace, etc. for example if the length of the string is 13, then insert a 0 as the second last character.