Get numeric value from an alpha field Get numeric value from an alpha field worldatlas (MIS) (OP) 4 Oct 05 12:24 I have a field that is A17 format. However, the data contain alpha & numeric. For example:CREPRECD-SRF34568970I want to be able to grab 3456 and 8970 numeric value ONLY. Is there a function that allows me to do that.Thank you. RE: Get numeric value from an alpha field craigiep (Programmer) 4 Oct 05 19:12 You could use EDIT egDEFINE FILE XNFIELD/P15 = EDIT(ALPHAFIELD);ENDIf ALPHAFIELD contains only numeric values then NFIELD will be that numeric value, otherwise if ALPHAFIELD contains alpha chars then the value of NFIELD will be zero.One problem may be that if the numeric value takes up the entire 17 available positions then I don't think EDIT will work, but it should be ok up to around 12 or 15.