SSIS derived column remove text from string, keep only numeric values

Question

I am trying to remove text from a specific column and only keep the numeric values. I tried to use a derived column and also tried to search for the answer, but did not find the solution.

For example, the table looks like this:

order_number
1001
1002 k
1003
text
1004
aa 1007

I hope somebody could help me with this. Thanks in advance

This is the error I get:

Answer 1

You could use a script component (make sure to add an output column (outordernumber)):

if(!Row.ordernumber_IsNull){
    Row.outordernumber = System.Text.RegularExpressions.Regex.Replace(Row.ordernumber, "[^0-9]", "")
}else{
    Row.outordernumber_IsNull = true;
}   

I think you missed this step:

Package Result: