Parsing and then Reconstituting Name

[irunergoiam]

I have a text field where names are recorded as follows:

"[Last Name], [First Name] [MI]"

Where [MI] can be null

I am trying to find/write an expression that will give me the name as follows:

"[First Name] [Last Name]"

Where the [MI] (if it exists) is not included.

Any guidance would be greatly appreciated.

 

[irunergoiam]

As an example:

"Smith, Jason L" would return "Jason Smith"
"Jones, Mike" would return "Mike Smith"

 

[Ron_dK]

Make a query and include the tree fields. In the Query make a new field something like :
expres: [first-name] & " " & [last-name]

 

[irunergoiam]

I'm starting with one field that has the last name, first name and may or may not have a middle initial.

Trying to write an expression that drops the middle initial (if it exists) and reconstitutes the field as "[First Name]&" "& [Last Name]"