Six Stars

Move mathematical symbol to First position

Hello all,

 

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.

Is it possible?

 

For example :

 

Column AExpected Result
45.50 --45.5
8841.74 --8841.74
966966
50.2550.25
23.523.5
445445
415.99--415.99

 

 

Can you advice on this please?

 

Best regards,

asadasing

1 ACCEPTED SOLUTION

Accepted Solutions
Nine Stars

Re: Move mathematical symbol to First position

By using tMap you can achieve this.

 

Talend1.PNGTalend2.PNG

Veeranjaneyulu Boppudi
2 REPLIES
Nine Stars

Re: Move mathematical symbol to First position

By using tMap you can achieve this.

 

Talend1.PNGTalend2.PNG

Veeranjaneyulu Boppudi
Six Stars

Re: Move mathematical symbol to First position

I can guarantee that you are doing an awesome work.

Thank you very much for your help.