I recently started an IT program and have been taking some classes, specifically an intro programming class where I'm learning C from scratch. Nothing crazy, just making useless programs you can run on the terminal to calculate arithmetic chit and the like, and then fuking around with an arduino board. I'm real ecited though and would like to at least attempt to do something useful. There's probably programs that can already do this for me, but I'd like to do it on my own.

So basically let's say I have a directory full of files with an ID as their title. For example something like ROCK-012, or RAP-336. Each of these files has an artist of course. Let's say ROCK-012 has an artist called "Van Halen". I have an excel file with a table. In column 1 I have Van Halen in every single cell, going all the way down. In column 2 I have the "ID" of every song by Van Halen. So column 1 has "Van Halen" and the cell to the right of it has "ROCK-012"; and so on.

I would like to do something very simple, but with automation. I want to code a program, in whatever language is best, that can "Read" the excel file/table and see all the file IDs which are associated with Van Halen. THen I was it to scan a folder on windows explorer for me, and find all the files that have any one of those IDs in their file name (even better if its not case sensitive - or whole case), and then move that file into a folder titled "Van Halen".

How difficult would this be? And what is the best language or CLI or whatever to perform this with? I am probably getting ahead of myself but this is an actual issue I have that I would love to solve on my own y making a script.

Poverty reps for answers!

pls

fuk u pheggots

Found out the best way to do it is to use VBA code with the File System Object operator

I used C# to make a CRUD app using data in excel file using a library. Was slow as **** but worked lol. I would recommend java/c# because they will have the libraries you need

python with pandas is what I use. I do this with large excel sheets (reading, filtering, and saving million line excel files in ~30 seconds).