Partial Column Sorting
Partial Column Sorting
woas74
Posts: 2Questions: 1Answers: 0
Hi, what is the best way to partially sort(order a column) which has a prefix to it. For example I have Prof. Aaaa and Dr. Bbbb
I would like to sort the column by Aaaa and Bbbb and not By Prof. or Dr.
Thanks!
This discussion has been closed.
Answers
If the data is coming from a database, I would store the prefixes in a separate column in the database.
Hi, thanks for your answer but I don't understand what you mean. How does that help me show the data in a table and also sort by the correct substring?