Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Exclude all numerical data in query

HI all, i wish to filter out all numerical values in the query - how can I do that? 

 

e.g., filter out 123123, 234234, 23312 and keep only the text character abgh, sjgfn, sdjf

 

 

THANKs!!!

Need Help
  • v-angzheng-msft's avatar
    v-angzheng-msft
    5 years ago

    Hi,Anonymous 

    Try to use Text.Select or Text.Remove to add a new column in PowerQuery. These two functions have their own advantages and disadvantages. Choose the function that you need.

     

    For references:

    Text.Remove 

    Text.Select 

     

    Hope this helps

     

    Best Regards,
    Community Support Team _ Zeon Zheng
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

2 Replies