Forum Discussion

kevinsray's avatar
kevinsray
Helper II
4 years ago
Solved

Extracting Numbers from column

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.

Need Help
  • ryan_mayu's avatar
    ryan_mayu
    4 years ago

    kevinsray 

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

     

1 Reply

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    4 years ago

    kevinsray 

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