Trying to manipulate data in a query field called NAM1 using expression builder. Don't know how to separate the data and reverse it. There is other data mixed in with this field. I only want the data in this field that is separated by a comma and a space. I would be ok to seperate the data into to separate fields.
Here's an example of the data:
PERKINS, JEFFREY D
Here's how I want it:
JEFFREY D PERKINS
Can you help?
Here's an example of the data:
PERKINS, JEFFREY D
Here's how I want it:
JEFFREY D PERKINS
Can you help?