Parse Out Integers

Discussion created by craiguwl on Jun 26, 2012
Latest reply on Jun 26, 2012 by craiguwl
Hi all.  I'm looking for a calculation that I can use to parse out integer values only in a field.  I currently have a house number field that contains values such as 100, 215, 300A.  I'm looking for a field calculation that will move all of these values to a new field and take the "A" out of the 300 house number.  Any help would be greatly appreciated.