goterrier

Thanks!! Will try them out

Definately will have 1 2 or 3 before the .csv Any numbers before the 1 2 or 3 shall be excluded.

Merge them into a single csv and the single csv name will be the filenames exclude the 1 2 or 3. E.g. aaa1.csv aaa2.csv aaa3.csv So Merge filename should be aaa-merge.csv Any ideas?

Need help~ I have a directory with multiple csv. e.g. aaa1.csv aaa2.csv aaa3.csv aaa4.csv aaa5.csv after using powershell, I can merge those csv into merge.csv how do I list the *.csv and only take the string before 1.csv and rename from merge.csv into aaa-merge.csv ? anyone can advice?