Please, I need your help to solve a problem I had after I concatenated "Lastname, first name, and middle name. I want the characters to look like this, e.g., Johnson, Smart B. However, I was successful doing that, but I have two different people in different departments with the names (e.g., Smith, Johnson L maybe in English dept and another person bearing the same Smith, Johnson L in French Dept). Please, how can I solve this problem before joining the data set? How do I remove the initial from one of the names to make the concatenation or names unique by person? Show less
... View more