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.
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.
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 :)
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.
![PowerShell Intermediate Tutorial 6 : JSON & APIs [Intermediate]](http://i.ytimg.com/vi/Y0HP-DatueU/mqdefault.jpg)
![PowerShell Intermediate Tutorial 6 : JSON & APIs [Intermediate]](/img/tr.png)
![PowerShell Tutorial 10 : Error Handling [Beginners]](http://i.ytimg.com/vi/3QEl0D3kNZ4/mqdefault.jpg)
Exelent. Great explication. Tranks
Can you explain how to merge multuple csv files and how to compare the values between columns and print a conclusion?
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.
hi how do i remove rows with dates older than xx/xx/xxxx and save as new file?
HI :) I will be posting a video on this soon, once I record it ill be posting the release date in a comment :)
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.
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 :)
The video will be online on April 11 at 11am EST :)
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.
When I try Add-Content "file.csv" "`tUploaded" it adds "Uploaded" as a new row instead of as a value in a 4th column
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 :)
@@Tenorosa I have recorded the video, it will be up on the channel on September 9th at 12PM EST
Do you have a video on how to replace the header row for CSV files for all the files in a folder?
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 :)
Hi Kerri, the video will be out on April 21st :)