https://systematic.workato.com/t5/community-chat/change-position-of-text-from-the-end-to-the-beginning-in-data/m-p/6490#M179 <P>Hi&nbsp;<a href="https://systematic.workato.com/t5/user/viewprofilepage/user-id/9851">@osherachamim</a>&nbsp;,<BR />Here is the formula for your requirement -&nbsp;</P><LI-CODE lang="ruby">&lt;map the datapill of the string type&gt;.split(" ").last + " " + &lt;map the datapill of the string type&gt;.split(" ").first</LI-CODE><P>&nbsp;</P> Tue, 23 Apr 2024 12:02:52 GMT Prajwal 2024-04-23T12:02:52Z https://systematic.workato.com/t5/community-chat/change-position-of-text-from-the-end-to-the-beginning-in-data/m-p/5684#M125 <H3><A title="Change position of text from the end to the beginning in data fill" href="https://systematic.workato.com/t5/workato-pros-discussion-board/change-position-of-text-from-the-end-to-the-beginning-in-data/td-p/5683" target="_blank">Change position of text from the end to the beginning in data fill</A></H3><P>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:)&nbsp;</P> Sat, 25 Nov 2023 22:29:10 GMT https://systematic.workato.com/t5/community-chat/change-position-of-text-from-the-end-to-the-beginning-in-data/m-p/5684#M125 osherachamim 2023-11-25T22:29:10Z https://systematic.workato.com/t5/community-chat/change-position-of-text-from-the-end-to-the-beginning-in-data/m-p/6487#M178 <P><a href="https://systematic.workato.com/t5/user/viewprofilepage/user-id/9851">@osherachamim</a>&nbsp;did you already find a solution?&nbsp;</P> Tue, 23 Apr 2024 11:10:47 GMT https://systematic.workato.com/t5/community-chat/change-position-of-text-from-the-end-to-the-beginning-in-data/m-p/6487#M178 vijayalakshmi 2024-04-23T11:10:47Z https://systematic.workato.com/t5/community-chat/change-position-of-text-from-the-end-to-the-beginning-in-data/m-p/6490#M179 <P>Hi&nbsp;<a href="https://systematic.workato.com/t5/user/viewprofilepage/user-id/9851">@osherachamim</a>&nbsp;,<BR />Here is the formula for your requirement -&nbsp;</P><LI-CODE lang="ruby">&lt;map the datapill of the string type&gt;.split(" ").last + " " + &lt;map the datapill of the string type&gt;.split(" ").first</LI-CODE><P>&nbsp;</P> Tue, 23 Apr 2024 12:02:52 GMT https://systematic.workato.com/t5/community-chat/change-position-of-text-from-the-end-to-the-beginning-in-data/m-p/6490#M179 Prajwal 2024-04-23T12:02:52Z https://systematic.workato.com/t5/community-chat/change-position-of-text-from-the-end-to-the-beginning-in-data/m-p/6528#M183 <P>Hi&nbsp;<a href="https://systematic.workato.com/t5/user/viewprofilepage/user-id/9851">@osherachamim</a>&nbsp;,</P><P>You can use the fomula like this.<BR /><BR /><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot 2024-04-24 154447.png" style="width: 400px;"><img src="https://systematic.workato.com/t5/image/serverpage/image-id/1179iBA63A597B20509D5/image-size/medium/is-moderation-mode/true?v=v2&amp;px=400" role="button" title="Screenshot 2024-04-24 154447.png" alt="Screenshot 2024-04-24 154447.png" /></span></P> Wed, 24 Apr 2024 10:16:57 GMT https://systematic.workato.com/t5/community-chat/change-position-of-text-from-the-end-to-the-beginning-in-data/m-p/6528#M183 girish-naralla 2024-04-24T10:16:57Z