Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 fil...
  • darshaningale's avatar
    4 years ago

    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.

  • darshaningale's avatar
    darshaningale
    4 years ago

    the file is not accessible.