Is it possible to compare two or more files using not their whole names, but parts of their names?
Like this: Let's say I am deploying a .sql file with the name a_b_DEV.sql and it creates a log file that is called a_b_DEV_log.txt.
Now, I have several of those .sql files, such as: a_b_OFF.sql, ..._TST.sql, ..._ABD.sql, and they all create their own log files.But the beginning of their names (a_b_) stay the same.
What I am trying to do is have ONE .vbs file that emails the user with the right log file attached. Is it possible to achieve that. Sorry, it is in vbs, but my main script is in batch. I had to write the emailer in vbs. If I accomplish it, it would be a lot more dynamic and organized, compared now, where I have separate emailer .vbs files for each one of those OFF, TST, ABDs.