Remove prefix

[msve]

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. 

[messi007 · Accepted solution]

@msve,

Please see below:

Attached the workflow,

Hope this helps!

Regards

[HomesickSurfer]

Hi @msve 

IF Length(GetWord([First Name], 0))=1 THEN GetWord([First Name], 1) ELSE [First Name] ENDIF

[msve]

 @messi007 Thank you for the quick response. I was able to implement your solution. Thank you.