Actively Monitor a shared directory for a new CSV file, rename a portion of the filename then open the spreadsheet and find and replace a name

[MilesIT]

Hi I have a complex issue that should be very simple..

There has been a business name change, however the original name has been hardcoded into some software that they are going to charge mega money to fix so I need a solution that some genius might be able to help with
Every day at 6.05am the software writes a csv to a directory -
C:\Program Files (x86)\tech Technologies\Schedule Engine\Reports\20210129 (A new folder is created everyday and named with the days date the CS's are then placed in the directory)


OLDBUSINESS_NAME_20210123_004_Transactions_00.csv (There can be multiple versions of this 01,02,03 etc)
OLDBUSINESS_NAME_20210129_010_Accounts_05.csv (There can be multiple versions of this 01,02,03 etc)
OLDBUSINESS_NAME_20210129_010_Customers_04.csv (There can be multiple versions of this 01,02,03 etc)

1. I need to rename all these csv files within the Reports directory within each folder from example: OLDBUSINESS_NAME_20210123_004_Transactions_00.csv to NEWBUSINESS_NAME_20210123_004_Transactions_00.csv

2. I need to open each CSV within the reports directory (Has multiple folders date named on every day its written) and do a find and replace looking for "OLDBUSINESSNAME" and replacing with "NEWBUSINESSNAME"

I also need this to run everyday at 6.10am...

Help I'm going grey

Thanks in advance, I'm sure this will be a challenge for someone to assist with.

Miles

 

[MilesIT]

This powershell command will do the text replacement within the csv files.

powershell -Command "(gc INPUT.csv) -replace 'oldbusiness', 'newbusiness' | Out-File -encoding ASCII OUTPUT.csv"