Skip to Content
0
Former Member
Feb 14, 2011 at 09:03 AM

Functional module on extracting character and numeric value

29 Views

Dear All,

I have one file which type is character. It contains alphanumeric values. (Ex. 500G & 7KG etc.) I want to extract numeric and characteristic values.

There is no pre-defined no. of digits means actual value may have 5, 6 7.. digits.

Ex.

1) Actual Value: 8975G

Target Value: : 8975

2) Actual Value: 500KG

Target Value: 500000

Is there any standard function are available for this task?

I really appreciate your input on this.

Regards,

Rishit