Forum Discussion
Remove strings below certain digits in column
Hi,
Hope someone can help me with the folowing.
I have a below mentioned column.
In power query, I want to remove all cells with less or more than than 7 digits.
How can I do that, is there a filter for that?
Thanks for your help!
John
Add a length column and get length of the data column.
Add another conditional column based on length column and data column.
Delete data column and length column and use the new conditional column.
Regards
DI
Did I answer your question? Mark my post as a solution, this will help others!
Kudos are also welcome.the file is not accessible.
4 Replies
Add a length column and get length of the data column.
Add another conditional column based on length column and data column.
Delete data column and length column and use the new conditional column.
Regards
DI
Did I answer your question? Mark my post as a solution, this will help others!
Kudos are also welcome.the file is not accessible.