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))