Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Extract numbers of certain digits

Hello community,

I am struggling with this.

How can I do to extract in several rows or columns numbers that have 6 digits and that the first digit starts from 1 to 9. Ignore numbers that start with 0. Repeated numbers that are drawn only 1 time. ???

 

 

Need Help
Tips and Tricks

2 Replies

    • ercc026's avatar
      ercc026
      New Member
      3 years ago

      Greg_Deckler Yeah. All the numbers are in one cell.
      Context: I have a column that contains many rows and each row contains many numbers, letters and symbols.
      What I did was extract numbers using the following formula Table.AddColumn(#"Changed type", "NUMBERS", each Text.Select([QUERY],{"0".."9"," "})) and got the extraction of many numbers in a cell.
      Unfortunately I have numbers that don't work and I want to extract only 6 digit numbers that start with 1,2,3,4,5,6,7,8 and 9. Ignore those that start with 0.
      I would like to get the result as in the photo.