PowerShell Intermediate Tutorial 5 : CSV Files [Intermediate]

[@baury]

Exelent. Great explication. Tranks

[@rodrigonorambuena8896]

Hi! I loved your explanations!! Can I get thr result of .csv and pass it to an SELECT FROM? When the csv has one record the sentence split it and I don’t know why. Ie: 124 results three queries, select 1, select 2, select 4… but if I get more data, ie 1234, 112 works fine.

[@muskanmishra715]

Can you explain how to merge multuple csv files and how to compare the values between columns and print a conclusion?

[@suvendudey6923]

How to append data in rows from multiple .csv files with same column name into a single .csv file. also there could be NULL under any column. ? can I create and save it as .ps1 file so that one click it works as automation.

[@jackedprogrammer]

Hi Suvendu, great question I will be recording the answer to this questions and posting it very soon, I will comment again here with the release date, should be around mid April :)

[@jackedprogrammer]

The video will be online on April 11 at 11am EST :)

[@Tenorosa]

Can you do a tutorial on how to add a comment to the same csv you import earlier? For example, I upload users to a webform (3 columns: firstname, lastname, ID), and I want PoSh to then add a 4th column 'status' to the row showing "done" or something after it attempted to upload.

[@Tenorosa]

When I try Add-Content "file.csv" "`tUploaded" it adds "Uploaded" as a new row instead of as a value in a 4th column

[@jackedprogrammer]

I can make a video for that, I`ve done that task in the past, Ill work on that video in the next few days and should be up next week :)

[@jackedprogrammer]

@@Tenorosa I have recorded the video, it will be up on the channel on September 9th at 12PM EST

[@kerrianguiano]

Do you have a video on how to replace the header row for CSV files for all the files in a folder?

[@jackedprogrammer]

Hi Kerri, I do not but I find this very useful I will be making this video and ill comment again with the release date shortly :)

[@jackedprogrammer]

Hi Kerri, the video will be out on April 21st :)

[@schooltp]

hi how do i remove rows with dates older than xx/xx/xxxx and save as new file?

[@jackedprogrammer]

HI :) I will be posting a video on this soon, once I record it ill be posting the release date in a comment :)