I thought I was going to have a super easy thing to do.
I want to take a name and create a field that has it in the correct order... NO... I don't want to go to settings and select my preference. For reasons outside of this question pretend that a Name column holds "Last, First". I wanted to make it First Last. (not a settings thing)
Calculated fields don't have the requisite things, so I'm actually happy that I am forced to learn more power fx. Simply, I figured a Concat (second part, " ", first part) shouldn't be that hard. I should look for the comma and use it. I expected something like this to work
Concatenate(
Right(name, Len(name)-Find(",",name)-2),
" ",
Left(name, Find(",",name)-1)
)
Or similar. I have reached the point of I can get the Left(name,10) - hard coded number)
And I can even do Left(name,Len(name))
but for some reason any time I add a "Find" to it, it won't save.
