Hello,
I have a data with first name, middle name and last name. I split the column using test to columns, but there few names that has single letter prefix that I would like to remove too.
Solved! Go to Solution.
Hi @msve
IF Length(GetWord([First Name], 0))=1 THEN GetWord([First Name], 1) ELSE [First Name] ENDIF
@messi007 Thank you for the quick response. I was able to implement your solution. Thank you.