I have a field called agent name which has names in format 'Lastname, Firstname'. There is a space after comma. There are also several agents who has 2 words in their first name.
If i request for help to convert this field to populate in format Firstname Lastname(with space between first and lastname)
4 risposte
@Nirav Dedhia
Try this:
TRIM(SPLIT([Full name], ',', 2)) + ' ' + SPLIT([Full name], ',', 1)
Let me know if it works
Thanks,
Said
(Please upvote all my answers and select them as the best if you found them helpful)
