Skip to Content
0
Former Member
Dec 08, 2011 at 03:44 PM

Transformation -> String to Number

626 Views

Morning,

I was wondering if it is at all possible to write a formula within a transformation to convert a string to a number. My situation...I have numerous strings which contain words and a set of numbers. I would like only to convert the string to numeric with only the number set.

for example:

string 1 -> '123 world' -> I want only 123

string 2 -> 'world 123' -> I want only 123

other possibilities...

Thoughts?

If this can't be done, I would imagine I would need to create an advanced ABAP routine and call a convert function.

Thanks!