Hi there,
Back with another question.
I have a Full Name column in varying format:
Alex McCandless
Alexander David Thoreau
Bobby Del Rio
Cameron Diaz Camilo Carter
Dave O'Donald
Jack E. Topez
...
and I need to parse this into three columns:
- First Name - the first word of the string, seems easily accomplished with the split column tile
- Last Name - the last word of the string, how can this be done?
- Middle Name - anything in between First Name and Last Name, I was thinking substring of the Full Name up to LENGTH of the First Name and ends with a space, but unsure how to accomplish
Thank you in advance for any advice!