AnsweredAssumed Answered

Remove middle initial from Contact Name on flat file

Question asked by NeilFlores4571 on Aug 10, 2015
Latest reply on Sep 4, 2015 by NeilFlores4571

Hi,
I have a flat file that is picked up daily, and I need to update rows on a single column as follows:

 

I have a column for Contact Name, and those names contain a middle initial (i.e. LINDSEY N RHOADES) and before I can update our db I need to convert it to only LINDSEY RHOADES. I do this in Excel with the below formula, but is there a similar way to do this in Boomi without Java/Groovy, or am I stuck coding? Thanks so much!

 

LEFT(A1,SEARCH(" ",A1)) & RIGHT(A1,LEN(A1)-SEARCH(" ",A1,SEARCH(" ",A1)+1))

Outcomes