I have a column that has first and last name or it may have first, middle and
last name. I need to know how to pull the first name in a separate column
and also pull the last name into another column. I need to know how to
ignore the middle name, if applicable.