1 Reply Latest reply on Sep 19, 2013 6:59 AM by philmodjunk





           I need to recode a field;  OLD / NEW  1/1   2/1   3/2   4/2   5/3   6/3  7/4   8/4   9/5   10/5

           There is no recode command; What would you suggest?  

           Divide by 2 and round? Can I get it to consistently round up (which is what i need)

           A series of if conditionals?

           I look forward to whatever assistance people can offer.

           - Michael Donahue


        • 1. Re: recoding

               Is this data in a number field?

               Replace Field Contents can modify a specified field for every field in your current found set--which can be all records in your table and a calculaiton can be used to do the modification so the resulting value in the field can be different in each record and determined by the data present in your current field.

               Ceiling can be used to round up fractional portions. Ceiling ( 1/3 ) returns 1 for example.

               Thus, you can use an expression such as Ceiling ( YourTable::Field / 2 ) with the Calculaiton option available in Replace Field Contents.