Conversion function

josemathew · Post by **josemathew** » Thu May 15, 2008 3:09 am

Hi All,
I have a requirement in which i have to get only the numeric values from a string , which consistes of numeric as well as other characters.Eg: String is "A123-6S". From this i want only 1236. i.e, only the numeric part.

In Server edition we used OConv(String,"MCN") which gave only the numeric values.Here in EE , which conversion function can exactly give only numeric values.?

Thanks in advance

Jm

bkumar103 · Post by **bkumar103** » Thu May 15, 2008 3:21 am

you can try with convert function.

josemathew · Post by **josemathew** » Thu May 15, 2008 3:38 am

Thanks for the response..But here i need to remove all kind of alphabets and other symbols(like ., - , _ etc) from the string. We are not sure about the knd of characers present in the string. That is why here if we use the Convert function, the from list and replace list are not clear..

Please give more input..Any other function by which the conversion can be done easily..

Regards
Jm

ray.wurlod · Post by **ray.wurlod** » Fri May 16, 2008 6:35 am

For starters, stop thinking like a server developer.

You will have to create your own function. Test each character and, if its value falls between 48 and 57 inclusive append that character to the initially empty result variable.

bkumar103 · Post by **bkumar103** » Fri May 16, 2008 7:27 am

If you dont have any definitive list of character then it would be better to create a parallel routine in C++ as Ray suggested and call from transformer. To check for the process for creating subrotine you can search the forum... Many input has been provided already.