OneStop Posted January 5, 2018 Share Posted January 5, 2018 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? Link to comment Share on other sites More sharing options...
siroos12 Posted January 5, 2018 Share Posted January 5, 2018 (edited) 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 1 Link to comment Share on other sites More sharing options...
LaRetta Posted January 6, 2018 Share Posted January 6, 2018 22 hours ago, siroos12 said: Search for "-" in the filed. Not quite. OneStop, you'll need to search for *- 2 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 2316 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now