Identify " " and ","

[jgelpi16]

I have a field that has a name in it. The name could be a business name or an individual's name. I have a separate field that identifies it as a business or individual. What I need to do is if it is an individual's name I need to split it out to Last Name, First Name, MI in separate fields. If it is a business I need to remove a "," if it exists and just replace it with a " ". I would like to do all of this in one query. However, if it does not work I am ok with using VBA. My ultimate desired result is a ".csv" file.

[jgelpi16]

I forgot to mention my name layout is always "LastName FirstName MI" within the current field.