PowerShell Tutorials : Editing CSV files (Adding columns, editing data)

How to edit CSV files using PowerShell. In this video ill be showing you how to edit CSV Files in powershell, from adding columns, caclulated columsn and just a new simple column with a set value, editing existing cell data.
Generate CSV files : www.convertcsv...
Tags:
PowerShell
CSV
Editing CSV files
Programming
Scripting
Automating
JackedProgrammer
Coding

[@koolaidkitten]

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.

[@jackedprogrammer]

No problem :) glad you enjoyed the video :) thank you for watching

[@user-fx9vq7gf3j]

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.

[@jackedprogrammer]

No problem :) glad you’re enjoying the videos :) and that’s awesome I’m sure you’ll be doing that no problem very soon

[@sleighbor]

@jackedprogrammer - These PowerShell/CSV video tutorials are fantastic. Thanks for sharing.

[@kennyawalker]

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

[@jackedprogrammer]

Thank you for the support, glad you're enjoying the videos! :)

[@PerfectRotMG]

This is what I needed, many thanks

[@jackedprogrammer]

No problem, glad you're enjoying the videos :)

[@MKcLTM]

Im newbie but i would go with $names |select first,last,@{n="FullName";e={$_.first + " " + $_.last}}

[@alladiakshay1557]

I am enjoying the videos 😁. Plz compare two Excel files

[@steevenbazin3937]

Hi, nice video !
Thanks a lot :)

[@jackedprogrammer]

No problem, glad you enjoyed the video :)

[@TheEmperorXavier]

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.

[@alpaslanakdag614]

Thanks a lot for this tutorial but could you explain how can we remove a member in array?

[@AlwaniAkber]

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?

[@jackedprogrammer]

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.

[@jeffsims5683]

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.

[@jeffsims5683]

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.

[@shhhhhhhhhhhhhhhshhhh]

You sir just got yourself another sub. Excellent walk throughs.

[@haczynn9043]

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

[@guangtingzoeli8330]

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?

[@leeblack2103]

Thank you!!!!!

[@radhesingh8083]

Hi your video is helpful for sure. But it adds column at the end. Is there a way to add column at the start ?

[@jackedprogrammer]

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

[@PrashantKumar-sh2yl]

COULD ANYONE TELL ME HOW TO CHANGE OR UPDATE THE EXISTING DATA OF CSV FILE WITH THE HELP OF POWERSHELL..

[@nwing1999]

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

[@jackedprogrammer]

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?

[@nwing1999]

@@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?

[@JohnSmith003]

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?

[@jackedprogrammer]

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 :)