Name formatting using a formula field

[KAPITYAN]

How can I format the Name in a reverse order by displaying first the first name instead of Last Name. My table has client' last name and first name in the same field, listed with last name first, with a comma, ie, Balot, Kevin. I want to reverse the name, keep them in one field, but put first names first, with no comma, ie, Kevin Balot

Is there a way to do that automatically so I don't have to make the changes manually?
 

[NailDyanC]

Hi,

Can you try to use this formula if this will work for you:

RIGHT([@field:Name], LEN([@field:Name]) - PATINDEX('%,%', [@field:Name])) + ' ' + SUBSTRING([@field:Name],0, CHARINDEX(',',[@field:Name]))

You just need to change the name of the field based on the field that you are using. 

[imJihyo]

Hey there! Just dropping caspio's function reference article here since they have samples about the functions mentioned above:

Function Reference - Caspio Online Help

Cheers!

- Jihyo ♥

[ParkLoey]

Hi! Just wanted to add to the reference above, here's their latest video on YouTube that shows how we can use SQL in their platform  

- LOEY