I have some rows looks empty but they have a tabulation and i want to remove them
Can you provide more detail about what you want to do? If you can share some sample data or at least a screenshot that would be helpful.
1 Like
Hi @ouaazzim do you know what the rows actually contain? Is it tab characters as your first post implies, or some other form of white space?
If it is all some form of white space, you could possibly use a row filter to remove them, with a regex pattern:
^\s*$
if it is purely tabs, then this could instead be ^\t*$
The above will work for matching a single column. You haven’t given us many clues, but can you identify the rows to remove by a single column being empty, or do you need to check multiple columns?
If you need to see that multiple columns are all white space, then first use a column aggregator to concatenate all columns excluding missing into a new column (specify no delimiter), then apply the above row filter to that new column.
2 Likes