How to select files based on the name?
1 view (last 30 days)
My dataset consists of about 6000 txt files. Every three files have same initial name but diffrent last name.I want to write a code that first select all the three files has same initial name and then combine them in one file and delete them from directory at the same time. This process repeats onward. In the end I will left with 2000 files only.
For example, 123x.txt, 123y.txt, 123z.txt..... it be one group and so on. 123.txt
Rik on 12 Jan 2022
First you need to retrieve all file names with dir. Then you can split the file name on the dots with the split function. After that you can use the unique function and generate the 3 source file names and the new file name.
The merging itself depends on the specifics of your files.