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!