Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filter out rows with sapces inbetween

I have a table with a column with these values. (these values are just example values. The real values are random)   ABCD JZIEKFFHE   HELLO WORLD JDJKA MISTER FUNNY HELLO PBI   The record...
Need Help
  • Vvelarde's avatar
    Vvelarde
    6 years ago

    Anonymous 

     

    You could try this

     

    = Table.SelectRows(#"Changed Type", each not Text.Contains([Column]," "))

     

    if the blank rows are also filtered out that means that are not real BLANKS , maybe had spaces.

     

     

    Regards

     

    Victor

     

ibarrau's avatar
ibarrau
Icon for Super User rankSuper User
6 years ago

Sorry SSS95 but we can only help you with the data you gave us. If you want to show us more in order to help, then do it 🙂
You can still use the function to filter avoiding what the text contains as I have shown. You can find the patterns of your data to clean it up with that example.

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Yes indeed ibarrau, as mentioned I've modified the post so it should be more clear now 🙂

  • Vvelarde's avatar
    Vvelarde
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Anonymous 

     

    You could try this

     

    = Table.SelectRows(#"Changed Type", each not Text.Contains([Column]," "))

     

    if the blank rows are also filtered out that means that are not real BLANKS , maybe had spaces.

     

     

    Regards

     

    Victor