Extracting only Numbers from a cell ( which also contains letters &Underscores)

[Masond3]

Hi All ,

Hoping this is an easy one,

How do i extract only the numbers from "Current" Column 

Current	ExpectedOutcome
L1_AUS_123123	123123
AUS_123123	123123
L5_AUS_123123	123123
L1_NZ_111111	111111
AUS_111111	111111

Looking forward to your assistance 

Regards

Masond3

[hellyars]

@Masond3 If that is the case, then the approach using the Cleansing Tool will not work as it will capture any number before the underscore. 

[Masond3]

Thank you all 🙂