Converting values to positive or negative in a row

Question

XXXXXXXXXXXXXXXXXXE1-2-5-59-2-10-29-56-172-501E2234152512

Above in the original table and I would like to change E1 to positive and E2 to negative. I know how to do it for columns but i have a lot of columns so is there a quicker way to convert the rows into negative/positive values faster?

Desired outcome:

XXXXXXXXXXXXXXXXXXE125592102956172501E2-2-3-4-1-5-2-5-1-2

DataNath · Accepted Answer

Not sure what you do with these numbers downstream or if you just need them converting for a view, but you could just keep them in string format to show the whole number. Double is the largest numeric data type but will still convert larger numbers into scientific notation. If these numbers will always be within a specified limit/degree of accuracy then you could convert to a FixedDecimal but if not then I'm not aware of any way to keep the full display and make them numeric. Have included a large number in this example (using the string method) just to show it working:

grazitti_sapna · Accepted Answer

@kv-defy, another solution to your problem.

Thanks!

Kurohits · Accepted Answer

Hi @kv-defy

Pretty easy with Multi Field formula tool. I have attached 2 methods. One is long and another is just one tool and job done. Check out and let me know if you need any further help.

Thanks

Rohit Gupta