Change position of text from the end to the beginning in data fill

[osherachamim]

Change position of text from the end to the beginning in data fill

Hey, I'm working on a project and I have data pill that brings me "last name first name" and I want to replace the order of them with formula..Didn't found any solution on workato doc..Please assist:) 

[vijayalakshmi]

@osherachamim did you already find a solution? 

[Prajwal · Accepted solution]

Hi @osherachamim ,
Here is the formula for your requirement - 

<map the datapill of the string type>.split(" ").last + " " + <map the datapill of the string type>.split(" ").first

[girish-naralla]

Hi @osherachamim ,

You can use the fomula like this.