I have thousands of CSV files with the approximately the following structure:
As you can see, the filename contains a timestamp. I'd like to add a new field to each of the csv files and populate the field with the filename, like so:
Of course, the "csv_" prefix is not really needed, just wanted to illustrate the idea. Any thoughts on how to do this? Is this something that can be achieved with Notepad++ or similar? Or will this require a more sophisticated approach?
I have very, very little experience in coding/programming, so I may need the potential ideas explained in the simplest way possible.
edit: SOLVED. I found a solution that helped me. I used the following in cmd: for /f %a in ('dir /b .csv') do for /f "tokens=" %b in (%a) do echo %b,%a >> all.csv