Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I'm trying to create a filter with the function "first_last_name" to show the distinct names but also to unify when the names have different letter cases. So I have the name Randy Joubert then I have it again as Randy joubert and I need to combine them in some way. Is that possible?
Thank you!
user
capitalize(first_last_name) as first_last_name
or
Upper(first_last_name) as first_last_name
UPPER(first_last_name) then they will be the same and you can do a distinct on them
user
capitalize(first_last_name) as first_last_name
or
Upper(first_last_name) as first_last_name
Thanks Rupam, but I'm getting "Error in expression"
what is the expression you are using
You were right, I made a mistake in my expression. Thank you!
Thank you!