Need Help on Formula or Routin !

Experts,

in my Transformation, i have data something like this..

"123 ABVFDSFSFSFSFf"

"23532 KJOWEENDSSFNXZC"

"12 MNPSDD"

"123456 JISDAKMNKRNJ"

Here , my first couple of char. are Digits, and remaining are chars. i have to load only Numerics. currently i am using formula to split and get the first 5 or 7 digits. But now all the records has diff. length of Digits.

So, 1st record might have first 3 digits ("123 ABVFDSFSFSFSFf") and 2nd records might have 5 ("23532 JOWEENDSSFNXZC")

and so on..

how do i get it done ?

What is common in all the records is SPACE. so what i was thinking , if somehow i can find the place for the "SPACE" then i can do substring ( Space -1 )

Does anybody know? how do i find the place of the SPACE ?

OR any other logic.

thanks

Edited by: honar on Mar 18, 2011 4:53 PM