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