listFirst and listLast

Hi,

I have column name frrom the db and stored full name with diffrent format such as:

1: Kohei, Doughlas
2: Billon, Kelly K
3: Ford, Henry, L

4. Collin, Herve Gilles

i used listfirst(name, ",") to return the last name and listLast(name," ") to return the first name.  However, if the name has middle name like #2 or #3 or #4 then first name is not return correctly.  What can i do to get the firstname return correct? can you please help?

thanks