Sorting alphabetically on name

Maria Lieberman

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

Rachel Martorelli-Oracle

I can't help with polish names, but for case issues EVALUATE('INITCAP(%1)', Table.ColumnName) , should do the trick

Maria Lieberman

Thank you Rachel!  I will try it!

Rachel Martorelli-Oracle

Hello PB,

  This is just a formula, you can use the formula editor to use it.

P B

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"]

Rachel Martorelli-Oracle

Square brackets

 

EVALUATE('INITCAP(%1)', "Candidate Personal Information"."Candidate Last Name")