![]() ![]() It has a column for the Mode, LastWriteTime, LengthName etc which I then have to manually delete, because Im using OpenOffice and need the list of files to compose a new CSV which Im then going to import into a database. ![]() ![]() But in the software I can see it if I scrolldown through every file. Using dir > list.csv will create the list I need in whichever directory im in, but it includes unnecessary information as well. 5 Ways to Unlock Your HP Laptop Without the Password. I exported it to csv, then open with excel but it only shown this columns: name, format, video format, audio format and text format, not the duration. The general syntax for the export-CSV in Powershell is: Get-Variable -name variable name Export-CSV path-to-file.csv. I.e, I want to ignore these 2 directories from my listing.Īlso, at the end of the listing, instead of showing it on the console screen, I want to export this list to a CSV file, where I can open it in a text editor or Microsoft Excel. Hit the Windows key, type Powershell ISE in the search bar, and select Run as administrator. In this very simple article, I'm going to share with you a script that I developed to meet a very common need in the daily lives of those who create courses and training, which is to create a spreadsheet or CSV file, containing the list of videos, size and duration of each video, in order to maintain the folder structure to be able to calculate the total duration of the videos and also to be able to add the total duration per directory and per file, to make this available on a course platform, for example.įor this example, I used my course files on Database on Azure, which are already separated by separate directories for each module:īut notice that there are 2 folders within the course directory, called "General" and "Marketing", which are promotional videos and I don't want to consider them to assemble and make available the training schedule or to calculate the total duration of the videos. Finally, I need to export to a CSV so I can sort to find my oldest content (to. Folder / Sub-Folder Name (s) Creation date (s) Last modified date (s) and SIZE of the contents of each of the lowest sub-directories. Career, Courses and Certifications (36) I need to capture and export-csv the following 'home' directory folders (a re-directed 'Documents' folder): Full path to the folder. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |