Reverse a string

[Anonymous]

How can I reverse a a full name and add a comma between each word?

Example: ”Johan Ericsen” should be ”Ericsen, Johan”

[ansrikanth · Accepted solution]

something like this should work.. 

With(
    {names: Split("FirstName LastName"," ")},
    Concatenate(Last(names).Result, ",", First(names).Result)
)

obv, this presumes you have only firstname lastname (no middle names and a space between names)

Thank you

-Srikanth

[Himanshu_90677]

Concatenate( LastName, ", ", FirstName )

[Anonymous]

I dont't have last and first name..

[Anonymous]

I dont't have last and first name..

[ansrikanth · Accepted solution]

@Anonymous 

I just gave firstname and last name as an example.. like how you gave an example of "Johan Ericsen".. If I have to use your example it self in the formula then it would be .. 

With(
    {names: Split("Johan Ericsen"," ")},
    Concatenate(Last(names).Result, ",", First(names).Result)
)

Hope that clears .. 

Thank you

-Srikanth

[Himanshu_90677]

try This

Mid(User().FullName,Find(" ",User().FullName)+1) & ", " & Left(User().FullName, Find(" ",User().FullName)-1)

[Anonymous]

thank you very much!

[Anonymous]

Thank you sir!