PowerShell Tutorial: Import & Export CSV Data 🔥⌨️ DevOps | Automation | Developer
HTML-код
- Опубликовано: 20 авг 2024
- Learn how to import and export CSV data in your PowerShell automation scripts! PowerShell has two built-in commands that enable you to import data from the local filesystem, or export arbitrary PowerShell objects back to the filesystem. You can use CSV to represent any kind of simple data, without having to install any additional modules or software beyond PowerShell itself.
The Import-Csv command allows you to specify a custom delimiter character, if your CSV file doesn't actually use a comma as its separator. You can also specify a custom delimiter character, when you export PowerShell objects to a CSV file.
📄 Import-Csv command ➡️ learn.microsof...
📄 Export-Csv command ➡️ learn.microsof...
Please follow me on these other social channels!
➡️ trevorsullivan...
➡️ github.com/pcg...
➡️ / pcgeek86
➡️ / trevorsullivan
➡️ / trevorsoftware
➡️ tiktok.com/pcg...
All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names,trademarks and brands does not imply endorsement.
#powershelltraining #powershellscripting #opensource #microsoft #csv #data #dataanalysis #dataanalyst #data #devops #coding #codinglife #sysadmin #software #developer
Contains information from "Electric Vehicle Population Data", which is made available here under the Open Database License (ODbL).
Happy to see videos with powershell topics again .. big fan of your powershell vidoes :) .. Thanks
Thank you for your kind comment! 🙂 I will produce more!
likewise!!
Thanks again for amazing CBT Nuggets tutorials. You are an excellent teacher!
Thanks!! I'm independent now, so please support this channel!
Thanks!
I don't use CSV much, well since ImportExcel 😂
Great point, John! But remember some people use PowerShell on Linux! 🙂🐧
Technology without good documentation is death.
Another one to go alongside these is ConvertTo-CSV.
@MethodOverRide Definitely!
May I ask how you've become so skilled in so many things? It's amazing to see you do some many things with so many different technologies. As a Jr. SysAdmin I become so overwhelmed even thinking about learning several scripting/programming languages, containerization, etc..
Thank you, I appreciate the kind comment and question! I've been doing this for over 20 years now. You just learn bit by bit. Keep a backlog of topics you want to learn, and practice, practice, practice.
It helps a lot to keep a big picture mindset and see how different pieces fit together. Don't pigeon-hole yourself as a "PowerShell developer" or "sysadmin" anything like that.
@@TrevorSullivan I believe that's my issue is thinking too much of myself as a SysAdmin and sticking to your basic technologies they'd use although the industry is developing. Do you use any specific software to manage your backlog or skills you want to learn? I've always thought about Notion.
@@TheRealJohnMadden Yes, check out my recent video on Joplin. It's part of my #opensource playlist! That's what I use to keep track of my work. ruclips.net/p/PLDbRgZ0OOEpWrhpGuSlRJEHsMvbjXMRob
@@TrevorSullivan You're so awesome! Btw, thank you for having such amazing CBT Nuggets content, you've helped me astronomically throughout the years!
@@TheRealJohnMadden Thank you! I am so glad to hear that you're making huge strides forward! I am currently independent though, so please just focus on supporting this channel. That would be so helpful for me to continue my work! 💟
Hi, I am trying to import a PUNJABI LANGUAGE FILE to GOOGLE SHEETS, upon importing I received "??? ?? ???? " as data in the google sheet form, the original language was nowhere to be found. Thanks in advance
do you have any course on powershell on udemy or any other platform?
Sorry I don't have any other courses at the moment. Keep following my RUclips channel though! I might put out more PowerShell videos.
@@TrevorSullivan ok thanks, please make a playlist like powershell from beginner to medium or advanced like that sir