I have a field called name
format is: Lastname, FirstName Middlename
I want to separate these three pieces of data into columns:
Last Name First Name Middle Initial
Notice I only want the first letter of the middlename. How should I go about doing this. I'm...