Oracle Communities

Oracle Analytics and AI

Child Item

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

Find more posts tagged with

Answers

Analyses

Comments

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