Can Workflow be programmed to change first name last name to last name, first name?

SELECTED ANSWER

replied on December 6, 2023

The more complicated part would be telling where one ends and the other begins because people have multiple first names or last names and not everybody hyphenates.

So you could have things like Mary Sue Jones or John Stewart Paul where sometimes it's hard to tell if the middle word is part of the first name or the last.

Since you're working with a limited set of names, you might be able to rule some of these cases out and narrow down the definition of what a "first name" is enough to do a pattern for pattern matching. At that point, Workflow could run and split the value into 2 fields.

2 0

replied on December 7, 2023 • Show version history

Thanks, Miruna. I was thinking, after I posted yesterday, that I seem to remember I can get Workflow to split the names into two tokens and then I can have it create a third token that would be built by switching the two with a comma in the middle. All of our employee names are set up with just one first name and one last name, we don't have anything complicated at the moment so I think this should work!

0 0

Question

Question

Can Workflow be programmed to change first name last name to last name, first name?

Answer

Replies

Sign in to reply to this post.