File Naming - PowerShell / Excel - 'Automatic' changes

Going through the process for changing the file names using Excel and PowerShell.

A simple show and tell - you won't be able to try this at the office as we don''t have access to PowerShell, however if you to have a go at home feel free!

Step 1 - Import folder information using Get & Transform Data
Step 2 - Add in columns and info for what to rename the files to
Step 3 - Edit the structure to match the Windows file system
Step 4 - Change the PowerShell Script to match the CSV structure - ensure all entries match
Step 5 - Run PowerShell Script

The idea then is to combine this with the other bits of work I've been doing where all the naming information has been gathered into Excel spreadsheets.

[sonnyrealjr]

do you have video more than like this example you're going to rename the file based on the data inside, which define in every header.

Example: My File inside
invoice no. | Doc type | Date tx | Tax Info | Company Code | Time Tx |
00001 | 01 |20230703| 123456 | 441 |120000

rename the file to:

where formats:

xxx – 3-digit company code registered in BIR

XXXX – 4-digit branch code registered in BIR

YYYYMMDD - transaction date (Year, Month, Day)

HHMM – transaction time (Hour, Minute)

Regular/SI/Return/Void – type of transaction

nnnn – file sequence number as this may depend on the number of transactions on a specific date and time. It starts at 0001 up to 9999.