Move characters

[OneStop]

I have a number field that some data was imported into incorrectly. Some of the numbers are supposed to be negative numbers like -10 but instead they were imported as 10-

 

How would I go about moving the - to the beginning of the field in front of the integers?

[siroos12]

Search for "-" in the filed.  This would find all negative numbers no matter if the "-" is in correct place or not.

 

When you got the found set, replace the field content with below calculation:

 

"-" & GetAsNumber ( MyTable:MyField )

Edited January 5, 2018 by siroos12

[LaRetta]

22 hours ago, siroos12 said:

Search for "-" in the filed. 

Not quite.  OneStop, you'll need to search for *-