Full name formatting

Q&A
, , ,
1

goodnight

Would there be a function where I can format a person’s name?

Example:

JOAO PAULO FERNANDO

stay: Joao Paulo Fernando

1 Like
2

Hi @GuiFox - Thanks for posting the question. I do not think QuickSight has any inbuilt function available to do this. Even if since the string length and number of spaces will vary, I believe it is very difficult to achieve at QuickSight side. It is better to create a script out of QuickSight and bring the data as per your format. QuickSight can change to upper and lower case.

Let’s hear from other experts on this, tagging @duncan @ErikG and @David_Wong

Regards - Sanjeeb

2 Likes
3

Hi @GuiFox
As @Sanjeeb2022 said no built in function and depends on the number of variations of names.
You could try to “locate” the spaces and the string between and “lower” the letters after the first letter. You have to do it for each part within an “ifelse”.
BR

2 Likes
4

Thanks @ErikG . The real issue is some names may have 2 spaces and some name may have 3 and more as well. So it will be tricky to handle all cases.

Regards - Sanjeeb

3 Likes
5

Hello @GuiFox, I found some very interesting options to run this conversion in your custom SQL query when building your dataset or creating a database view. Using a while loop in SQL doesn’t feel like the ideal solution, but it is also the most likely way to accomplish this.

Here is a stack overflow page with some possible solutions using SQL

@ErikG’s suggestion to locate spaces (Locate) and lower (toLower) character values would be the only way to accomplish in QuickSight, but it also doesn’t feel like the best solution.

I will tag this as a feature request for our support team, and mark this response as a workaround solution for now. If you have found another way to accomplish this, I would be interested to see what you did to make it work. Thank you!