Master.name field contains names formatted with a / delimeter and the last name is first. I need to separate them, then report with first name last name for output.
EG: Smith/John
Smith/Mary
Jones/Bill
needs to be converted to:
John Smith
Mary Smith
Bill Jones
Sometimes the field only contains a first name and it usually a company name. EG 123 contractor
or AAA builder
These should remain the same.
Any help with the formulas would be appreciated.
I tried using split but no getting any joy with that.
IP Logged
