cancel
Showing results for 
Search instead for 
Did you mean: 

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

osherachamim
Deputy Chef I
Deputy Chef I

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

1 ACCEPTED SOLUTION

Prajwal
Deputy Chef III
Deputy Chef III

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

 

Prajwal Prasanna

View solution in original post

3 REPLIES 3

vijayalakshmi
Deputy Chef II
Deputy Chef II

@osherachamim did you already find a solution? 

Prajwal
Deputy Chef III
Deputy Chef III

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

 

Prajwal Prasanna

girish-naralla
Deputy Chef II
Deputy Chef II

Hi @osherachamim ,

You can use the fomula like this.

Screenshot 2024-04-24 154447.png