SSIS Rearrange Full Name In Same Column

Viewed 265

I have an excel file to load into my database, I'd like to rearrange the name field to this

FIRSTNAME M LASTNAME

instead of the format it's in now which is

LASTNAME, FIRSTNAME M.

to keep it consistent with a previous load I have loaded into my database. Is it possible to do this somehow and put it into the same column? I've searched, and have only found that people have been wanting to split them into multiple columns.

Thanks in advance.

1 Answers
Related