Forum Discussion

maccaronda's avatar
maccaronda
Frequent Visitor
6 years ago
Solved

Extract Number from column

Hi there

 

I have a file that is messy as anything and I would like to extract the numbers out of a particular column (some have combination of numbers and text and others just numbers. The column looks like this (sorry I had to paste as plain text)

 

Column A

58443
SO Stage
W58843
W58843-PB

57684
SO Stage
W57684
W57684-PB

 

Then the final result should look like this 

 

Custom Column

58443

58843
58843


57684

57684
57684

 

Any help would be greatly appreciated!

Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi maccaronda 

     

    Try this 

    =Text.Select( [Column A], {"0".."9"} )

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

4 Replies

  • Mariusz's avatar
    Mariusz
    Community Champion
    6 years ago

    Hi maccaronda 

     

    Try this 

    =Text.Select( [Column A], {"0".."9"} )

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

    • TomMartens's avatar
      TomMartens
      Super User
      6 years ago

      Hey Mariusz ,

       

      this is a brilliant solution. I was looking for my approach, as I did not bookmark it. I'm happy that I did find your approach first, very elegant.

       

      ~Tom