Categories
Sorting alphabetically on name
Summary
Sorting alphabetically on name
Content
Hello - I have a sort on Candidate Name and I realized that names that are in lower case and names that have special letters (Polish letters) are dropping to the bottom/end of the list.
Has anyone else experienced this and is there a workaround?
Many thanks!
Regards,
Maria
Comments
-
I can't help with polish names, but for case issues EVALUATE('INITCAP(%1)', Table.ColumnName) , should do the trick
0 -
Thank you Rachel! I will try it!
0 -
Hello PB,
This is just a formula, you can use the formula editor to use it.
0 -
So I'm having problems. Was trying to use your formula for last name column from below. What am I doing wrong?
EVALUATE('INITCAP(%1)',["Candidate Personal Information"."Candidate Last Name"]
0 -
Square brackets
EVALUATE('INITCAP(%1)', "Candidate Personal Information"."Candidate Last Name")
0