{"id":2164,"date":"2010-05-07T14:55:01","date_gmt":"2010-05-07T22:55:01","guid":{"rendered":"http:\/\/www.sapien.com\/blog\/?p=2164"},"modified":"2010-05-07T14:55:29","modified_gmt":"2010-05-07T22:55:29","slug":"export-csv-now-what","status":"publish","type":"post","link":"https:\/\/dev.sapien.com\/blog\/2010\/05\/07\/export-csv-now-what\/","title":{"rendered":"Export-CSV, now what?"},"content":{"rendered":"

PowerShell 2.0 has added the ability to export and import objects and store them as CSV files. CSV (Comma Separated Values) files have been a common file format since they where first used around 1967 on IBM mainframes and have been in constant use since then.<\/p>\n

If you need to edit CSV files most people use Microsoft Excel, which registers as the default editor for the .CSV extension. This is fine on your desktop or laptop computer, but when was the last time you found a Windows 2008 R2 server with Microsoft Office installed?<\/p>\n

At that point, your friendly neighborhood administrator recommends using Notepad or some other general purpose text editor you may happen to have on your server or on your toolkit flash drive.<\/p>\n

While editing a CSV file in Notepad works, since it is a text file after all, it is far from ideal.<\/p>\n

So let me introduce PrimalCSV Community Edition:<\/p>\n

\"PrimalCSV\"<\/a><\/p>\n

PrimalCSV is a dedicated, single file CSV editor you can just place on your flash drive and carry around with you. Since it is a single executable file with as few dependencies as we could manage, this tool requires no installation. It is available in 32 and 64 bit versions.<\/p>\n

PrimalCSV is free for personal and non-profit use (please read the End-User-License-Agreement on first startup) and can be downloaded here: Community Tools<\/a>. Registration is required to access the Community Tools downloads.<\/p>\n

We know that there are a lot of features and tons of functionality that can be added to this. So please don’t hesitate to head over to our free tools support forum at http:\/\/support.sapien.com\/forum\/forum_topics.asp?FID=10<\/a> and let us know what you think.<\/p>\n","protected":false},"excerpt":{"rendered":"

PowerShell 2.0 has added the ability to export and import objects and store them as CSV files. CSV (Comma Separated Values) files have been a common file format since they where first used around 1967 on IBM mainframes and have been in constant use since then. If you need to edit CSV files most people […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[485,569,311,21,25],"tags":[1008,68,28,1014,1003],"class_list":["post-2164","post","type-post","status-publish","format-standard","hentry","category-community-tools","category-primalcsv","category-primaltools","category-software-news","category-windows-powershell","tag-community-tools","tag-csv","tag-powershell","tag-primalcsv","tag-primaltools"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t