Get numeric value from an alpha field
Get numeric value from an alpha field
(OP)
I have a field that is A17 format. However, the data contain alpha & numeric. For example:
CRE
PRE
CD-SRF
3456
8970
I want to be able to grab 3456 and 8970 numeric value ONLY. Is there a function that allows me to do that.
Thank you.
CRE
PRE
CD-SRF
3456
8970
I want to be able to grab 3456 and 8970 numeric value ONLY. Is there a function that allows me to do that.
Thank you.
Talk To Other Members
RE: Get numeric value from an alpha field
DEFINE FILE X
NFIELD/P15 = EDIT(ALPHAFIELD);
END
If 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.