Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filter rows starting with two numbers

Hey folks, 

 

I need to filter out the rows that start with two numbers (e.g. "15John"). Is there any way to do so in Power Query? 

 

 

Need Help

4 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    6 years ago

    Anonymous 

    Add this as a new column and filter only TRUE:

    = try Value.Is(Number.From(Text.Start([data],2)), type number) otherwise false



    ________________________

    Did I answer your question? Mark this post as a solution, this will help others!.

    I accept KUDOS 🙂

    YouTube, LinkedIn 

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hey Fowmy , thanks for the response. 

       

      The formula doesn't really work for me.

       

      I am not sure what you mean by 'type number', there is no fixed number I am looking for. It's all the rows that start with 2 numbers. (e.g. 12xx as well as 17xx)