topic Change position of text from the end to the beginning in data fill in Workato Pros Discussion Board https://systematic.workato.com/t5/workato-pros-discussion-board/change-position-of-text-from-the-end-to-the-beginning-in-data/m-p/5683#M2498 <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..<BR />Didn't found any solution on workato doc..<BR /><BR /><BR />Please assist:)&nbsp;</P> Sat, 25 Nov 2023 22:25:03 GMT osherachamim 2023-11-25T22:25:03Z Change position of text from the end to the beginning in data fill https://systematic.workato.com/t5/workato-pros-discussion-board/change-position-of-text-from-the-end-to-the-beginning-in-data/m-p/5683#M2498 <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..<BR />Didn't found any solution on workato doc..<BR /><BR /><BR />Please assist:)&nbsp;</P> Sat, 25 Nov 2023 22:25:03 GMT https://systematic.workato.com/t5/workato-pros-discussion-board/change-position-of-text-from-the-end-to-the-beginning-in-data/m-p/5683#M2498 osherachamim 2023-11-25T22:25:03Z Re: Change position of text from the end to the beginning in data fill https://systematic.workato.com/t5/workato-pros-discussion-board/change-position-of-text-from-the-end-to-the-beginning-in-data/m-p/5688#M2500 <P>You can likely do this by splitting the string based on the "space" between the words, But that will only if there are only 2 words.</P> Mon, 27 Nov 2023 12:16:03 GMT https://systematic.workato.com/t5/workato-pros-discussion-board/change-position-of-text-from-the-end-to-the-beginning-in-data/m-p/5688#M2500 rachelnatik 2023-11-27T12:16:03Z Re: Change position of text from the end to the beginning in data fill https://systematic.workato.com/t5/workato-pros-discussion-board/change-position-of-text-from-the-end-to-the-beginning-in-data/m-p/5689#M2501 <P>Hi&nbsp;<a href="https://systematic.workato.com/t5/user/viewprofilepage/user-id/9851">@osherachamim</a>, Have you already tried the reverse method?&nbsp;<BR /><BR /><A href="https://docs.workato.com/developing-connectors/sdk/sdk-reference/ruby_methods.html#reverse" target="_blank">https://docs.workato.com/developing-connectors/sdk/sdk-reference/ruby_methods.html#reverse</A><BR /><BR />Cheers,<BR />Chris<BR />&nbsp;</P> Mon, 27 Nov 2023 12:45:41 GMT https://systematic.workato.com/t5/workato-pros-discussion-board/change-position-of-text-from-the-end-to-the-beginning-in-data/m-p/5689#M2501 chris-wiechmann 2023-11-27T12:45:41Z