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

     

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
Community 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