Hello guys,
I use a QAAWS connection (Xcelsius) and i want do a custom sorting to a column of my bloc, the column consists of following cites “Casa, Agadir, Dakhla, Marrakech” and i want it becomes ----> “Agadir, Casa, Marrakech, Dakhla” which mean sorting A-Z and always Dakhla city in the end of the list how can i do that ?? i tried with adding an ASCII characters then sorting, by duplicate data list, concatenate all cities except “dakhla” city with empty space (=concatenate(" ", city)) then sort the column A-Z but without result always the same column with the same sort as it is in the database
Any help please.
Thank you
meriem (BOB member since 2013-03-21)