topic Re: Move mathematical symbol to First position in Talend Studio https://community.qlik.com/t5/Talend-Studio/Move-mathematical-symbol-to-First-position/m-p/2329122#M98339 <DIV class="lia-message-author-with-avatar"> <SPAN class="UserName lia-user-name lia-user-rank-Seven-Stars lia-component-message-view-widget-author-username"><SPAN class=""><A href="https://community.qlik.com/s/profile/0053p000007LLseAAG" target="_self">vboppudi</A>,&nbsp;</SPAN></SPAN> </DIV> <P>I can guarantee that you are doing an awesome work.</P> <P>Thank you very much for your help.</P> Tue, 30 Jan 2018 07:14:53 GMT RA6 2018-01-30T07:14:53Z Move mathematical symbol to First position https://community.qlik.com/t5/Talend-Studio/Move-mathematical-symbol-to-First-position/m-p/2329120#M98337 <P>Hello all,</P> <P>&nbsp;</P> <P>I have column A which contain negative sign - at the last position and i want to check if the value contains negative sign, then i want to move the symbol to the first position.</P> <P>Is it possible?</P> <P>&nbsp;</P> <P>For example :</P> <P>&nbsp;</P> <TABLE> <TBODY> <TR> <TD>Column A</TD> <TD>Expected Result</TD> </TR> <TR> <TD>45.50 -</TD> <TD>-45.5</TD> </TR> <TR> <TD>8841.74 -</TD> <TD>-8841.74</TD> </TR> <TR> <TD>966</TD> <TD>966</TD> </TR> <TR> <TD>50.25</TD> <TD>50.25</TD> </TR> <TR> <TD>23.5</TD> <TD>23.5</TD> </TR> <TR> <TD>445</TD> <TD>445</TD> </TR> <TR> <TD>415.99-</TD> <TD>-415.99</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>&nbsp;</P> <P>Can you&nbsp;advice on this please?</P> <P>&nbsp;</P> <P>Best regards,</P> <P>asadasing</P> Sat, 16 Nov 2024 08:47:41 GMT https://community.qlik.com/t5/Talend-Studio/Move-mathematical-symbol-to-First-position/m-p/2329120#M98337 RA6 2024-11-16T08:47:41Z Re: Move mathematical symbol to First position https://community.qlik.com/t5/Talend-Studio/Move-mathematical-symbol-to-First-position/m-p/2329121#M98338 <P>By using tMap you can achieve this.</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Talend1.PNG" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lsks.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/155189iEA05895503C9BE02/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Lsks.png" alt="0683p000009Lsks.png" /></span></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Talend2.PNG" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LsmP.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/138616iC0D9478B3273F6D2/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009LsmP.png" alt="0683p000009LsmP.png" /></span></SPAN></P> Mon, 29 Jan 2018 23:28:12 GMT https://community.qlik.com/t5/Talend-Studio/Move-mathematical-symbol-to-First-position/m-p/2329121#M98338 vboppudi 2018-01-29T23:28:12Z Re: Move mathematical symbol to First position https://community.qlik.com/t5/Talend-Studio/Move-mathematical-symbol-to-First-position/m-p/2329122#M98339 <DIV class="lia-message-author-with-avatar"> <SPAN class="UserName lia-user-name lia-user-rank-Seven-Stars lia-component-message-view-widget-author-username"><SPAN class=""><A href="https://community.qlik.com/s/profile/0053p000007LLseAAG" target="_self">vboppudi</A>,&nbsp;</SPAN></SPAN> </DIV> <P>I can guarantee that you are doing an awesome work.</P> <P>Thank you very much for your help.</P> Tue, 30 Jan 2018 07:14:53 GMT https://community.qlik.com/t5/Talend-Studio/Move-mathematical-symbol-to-First-position/m-p/2329122#M98339 RA6 2018-01-30T07:14:53Z