I need to get the column data out of the csv file and use one column to rename some elements and other columns to populate their properties. Sometimes I also need to read the names of the elements and their properties (as arrays) and export them to CSV.
My PS is connected to a document management software where I want to bulk modify files/folders and their properties by exporting/importing Excel files. I’m trying with CSV for now.
I don’t know if it’s the right approach but instead of directly piping the data from imported CSV, I wanted to have better control over each column of data (as an array) and then pass it further to bulk modify files in my integrated software.
Anyway, I’ll study more on all the commands and find a better way to achieve the same.
While PowerShell works with objects and their properties you usually have a rich experience using these objects and properties directly. Most of the time you export those objects to a flat text file you loose some of the functionality.
Regardless of that … the way you ask is a kind of
You may search for your actual issue … not for the way you think you should solve this issue.