Get numeric value from an alpha field

worldatlas · Oct 4, 2005

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.

craigiep · Oct 4, 2005

You could use EDIT eg

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.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Get numeric value from an alpha field

worldatlas

MIS

craigiep

Programmer

Similar threads

Part and Inventory Search

Sponsor