Remove strings below certain digits in column

[jwi1]

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

[darshaningale · Accepted solution]

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.

[jwi1]

have already find the solution myself, so problem solved.

Thanks for your advise,

John

[darshaningale · Accepted solution]

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.

[jwi1]

good day @darshaningale,

Can you please let me know how to do it in the test file I have attached?

testfile  

[darshaningale · Accepted solution]

the file is not accessible.