Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a list-box with some text values from the database. I am using an expression = Capitalize (Field) to get the correct format.
Now, when I go to Sort->Expression and Paste the same expression as above and put it to Ascending, I am not getting the Field sorted based on Alphabetical order. How can that be achieved?
Try correcting your correct format in the script
LOAD
Capitalize(FIELD) as FIELD,
....
then use alphabetical sort order in your list box.
Hi,
What is the order which it is showing, will you please share the example of what is expected and what it is showing.
Regards,
Kaushik Solanki
Properties . sort > check "A-Z" & uncheck expression
otherwise check load order "Original"
Try correcting your correct format in the script
LOAD
Capitalize(FIELD) as FIELD,
....
then use alphabetical sort order in your list box.
Thank you swuehl..that worked well...