Forum Discussion
Power Query Keeps FIltering Rows Instead of Deleting them
christeddy
Please try removing all non printable and extra characters first:
1. Select the Column you want to filter; select type: text in that column.
2.1 Transform> Format> Trim2.2 Transform> Format > Clean
3. Filter empty cells
If this does not work please try Adding a Column where you can select the characters from the column you want to filter.4.1 Insert the next sentence if you want to keep letters and numbers:
Text.Select([YourColumn], {"a".."z", "A".."Z", "0".."9"})
Finally filter empty cells.
I hope this helps. if so please mark it as a solution. Kudos are welcome.
4.2 Inster this sentence if you only want to keep numbers:
Text.Select([YourColumn], {"0".."9"})
christeddy
Please try removing all non printable and extra characters first:
1. Select the Column you want to filter; select type: text in that column.
2.1 Transform> Format> Trim
2.2 Transform> Format > Clean
3. Filter empty cells
If this does not work please try Adding a Column where you can select the characters from the column you want to filter.
4.1 Insert the next sentence if you want to keep letters and numbers:
Text.Select([YourColumn], {"a".."z", "A".."Z", "0".."9"})
Finally filter empty cells.
I hope this helps. if so please mark it as a solution. Kudos are welcome.
4.2 Inster this sentence if you only want to keep numbers:
Text.Select([YourColumn], {"0".."9"})
That worked, but i got another problem lol. Thank You so much.
christeddy we are here to help each other. please create a new post with the problem and someone in the community will try to resolve the new issue.
