Forum Discussion
Solved
How to filter wrong named files?
Dear Forum, Please help with my frist steps. I want to filter out all files, which does not match to some exact pattern. I have that patter, which is file should end with _CW<number>_<year>_<m...
Hi haykp
If you split the column by delimiter at every underscore _ then you can remove any blank rows from the final column (see image below) and you're left with the filenames you want.
Then tidy up by deleting the columns created by the 'split column by delimiter' step.
Duplicate the column first if you want to preserve the filenames.
Regards
Phil
Hi haykp
If you split the column by delimiter at every underscore _ then you can remove any blank rows from the final column (see image below) and you're left with the filenames you want.
Then tidy up by deleting the columns created by the 'split column by delimiter' step.
Duplicate the column first if you want to preserve the filenames.
Regards
Phil