Thank you. These tutorials are very useful. I am starting to dabble in PowerShell for my job and it's both tough and awesome. I'm still learning how to comb through AD to list certain security groups for specific computers or account expiration dates for a given set of users.
I have multiple order files but it does not generate a header, I need to export the order form and then convert into the CSV and then use It with my application to process (need to run the loop and all excel files convert from the folder and imported into another folder, where a parse happened and then the new header is being built, which video to see?
Hi Akber, if I understand correctly your looking to learn how to add headers to a csv file in powershell to csv files that have no headers to begin with? If so I have a solution for you if not can you clarify a bit more.
why we need input file and output file? So that means if I just add extra information to the excel and save as csv file, run the new command again, it doesn't work?
Do you have an example of creating a script to take the table output of an existing command and create the objects so that they are formatted into a CSV? For example alot of powershell commands print to screen the output but I would like to develop the understanding and skill to create my own script to format that data to CSV....So that I can also eventually take that CSV and save it as an xlsx file.
Found a solution - Use the Select-Object -Property command to get data from previous command outputs to then be able to Pipe those as object properties and values into a CSV file.
Hi i was having issues extracting a compare-object output to a csv file as in I got my difference but I want only specific column to fill up a existing csv file with headers any suggestion?? Thankyou in advance
Hi Benjamin, I just want to ask a few questions just to make sure I understand exactly, you're doing a compare object on 2 data sets and you are export the results of that compare object and you'd like im guessing the sideindicator to go into a specific column of a existing CSV file?
@@jackedprogrammer Thanks for responding but I figured out that part I just want to know how to not let the existing columns be overwritten by the export CSV like in the sense Fname Lname Uname and Password the compare-object fills in the needed columns but overwrites Uname and password Could you suggest how I can keep these columns?
Hi Just getting deeper into powershell and your videos are great. I receive csv files all the time and I need to strip out numbers before a comma and also swap a month JUN/MAY to MAY/JUN doing this with notepads ++ at the moment but dedius.. cheers
there is im pretty sure when you go to export you could just pipe it first to a select-object and put the columns in the order you`d want in the export, sorry for the late reply
hey thanks for this. im having some problems where i have a coloumn header in SQL Server called [Currency Code] and all i need to show inside that is "£" but when the sql script converts to csv the "£" shows as an "?" instead. also how can i just remove the coloumn header from my sql output?
Hey, if you're doing the export using powershell make sure to use the -encoding parameter and I usually set it to default I find that has the best results for me with special characters, I hope that helps :)
Hey man love your videos thus far. I just humbly ask that you upload your videos in 1080p 60fps. It’s kind of hard to see the words and it is PowerShell, which is text.
Hi am from tiktok good vids, am a helpdesk guy and I have to use PowerShell to rename stuff in office365, maybe you will do video about migrate users from Windows server to azure? About move exchange I saw a lot videos but there is a still a hole in videos about move fully to cloud
![PowerShell Intermediate Tutorial 5 : CSV Files [Intermediate]](http://i.ytimg.com/vi/xw6olVd7uBQ/mqdefault.jpg)
This really helped me sort out a project I was struggling to finish. Thanks
Thanks so much. I was really stumped when trying to figure out how to change all the values in a column. Your example really helped me out.
No problem :) glad you enjoyed the video :) thank you for watching
@jackedprogrammer - These PowerShell/CSV video tutorials are fantastic. Thanks for sharing.
Thank you. These tutorials are very useful. I am starting to dabble in PowerShell for my job and it's both tough and awesome. I'm still learning how to comb through AD to list certain security groups for specific computers or account expiration dates for a given set of users.
No problem :) glad you’re enjoying the videos :) and that’s awesome I’m sure you’ll be doing that no problem very soon
You sir just got yourself another sub. Excellent walk throughs.
I have multiple order files but it does not generate a header, I need to export the order form and then convert into the CSV and then use It with my application to process (need to run the loop and all excel files convert from the folder and imported into another folder, where a parse happened and then the new header is being built, which video to see?
Hi Akber, if I understand correctly your looking to learn how to add headers to a csv file in powershell to csv files that have no headers to begin with? If so I have a solution for you if not can you clarify a bit more.
why we need input file and output file? So that means if I just add extra information to the excel and save as csv file, run the new command again, it doesn't work?
Do you have an example of creating a script to take the table output of an existing command and create the objects so that they are formatted into a CSV? For example alot of powershell commands print to screen the output but I would like to develop the understanding and skill to create my own script to format that data to CSV....So that I can also eventually take that CSV and save it as an xlsx file.
Found a solution - Use the Select-Object -Property command to get data from previous command outputs to then be able to Pipe those as object properties and values into a CSV file.
Thanks a lot for this tutorial but could you explain how can we remove a member in array?
Hi i was having issues extracting a compare-object output to a csv file
as in I got my difference but I want only specific column to fill up a existing csv file with headers
any suggestion??
Thankyou in advance
Hi Benjamin, I just want to ask a few questions just to make sure I understand exactly, you're doing a compare object on 2 data sets and you are export the results of that compare object and you'd like im guessing the sideindicator to go into a specific column of a existing CSV file?
@@jackedprogrammer Thanks for responding but I figured out that part I just want to know how to not let the existing columns be overwritten by the export CSV
like in the sense Fname Lname Uname and Password
the compare-object fills in the needed columns but overwrites Uname and password
Could you suggest how I can keep these columns?
Hi Just getting deeper into powershell and your videos are great. I receive csv files all the time and I need to strip out numbers before a comma and also swap a month JUN/MAY to MAY/JUN doing this with notepads ++ at the moment but dedius.. cheers
Thank you for the support, glad you're enjoying the videos! :)
Hi your video is helpful for sure. But it adds column at the end. Is there a way to add column at the start ?
there is im pretty sure when you go to export you could just pipe it first to a select-object and put the columns in the order you`d want in the export, sorry for the late reply
hey thanks for this. im having some problems where i have a coloumn header in SQL Server called [Currency Code] and all i need to show inside that is "£" but when the sql script converts to csv the "£" shows as an "?" instead. also how can i just remove the coloumn header from my sql output?
Hey, if you're doing the export using powershell make sure to use the -encoding parameter and I usually set it to default I find that has the best results for me with special characters, I hope that helps :)
This is what I needed, many thanks
No problem, glad you're enjoying the videos :)
Hey man love your videos thus far.
I just humbly ask that you upload your videos in 1080p 60fps. It’s kind of hard to see the words and it is PowerShell, which is text.
COULD ANYONE TELL ME HOW TO CHANGE OR UPDATE THE EXISTING DATA OF CSV FILE WITH THE HELP OF POWERSHELL..
Hi, nice video !
Thanks a lot :)
No problem, glad you enjoyed the video :)
I am enjoying the videos 😁. Plz compare two Excel files
Hi am from tiktok good vids, am a helpdesk guy and I have to use PowerShell to rename stuff in office365, maybe you will do video about migrate users from Windows server to azure? About move exchange I saw a lot videos but there is a still a hole in videos about move fully to cloud
Im newbie but i would go with $names |select first,last,@{n="FullName";e={$_.first + " " + $_.last}}
Thank you!!!!!