Extracting Numbers from column

[kevinsray]

Hi All,

I have a column which consists of several formats of numbers, 12345/01 , 12345/02, CR12345.

I am trying to create a new column which will give me the result of 12345.

Have been struggling with this all day, but no luck.
And advice would be appreciated.

[ryan_mayu · Accepted solution]

@kevinsray 

maybe you can try column from examples. you can mannually type in the expected output until get all the correct outputs