{"id":584,"date":"2008-08-08T02:40:34","date_gmt":"2008-08-08T10:40:34","guid":{"rendered":"http:\/\/www.sapien.com\/blog\/2008\/08\/08\/new-primaltoys-object-for-easier-csv-handling\/"},"modified":"2008-08-13T14:01:09","modified_gmt":"2008-08-13T22:01:09","slug":"new-primaltoys-object-for-easier-csv-handling","status":"publish","type":"post","link":"https:\/\/dev.sapien.com\/blog\/2008\/08\/08\/new-primaltoys-object-for-easier-csv-handling\/","title":{"rendered":"New PrimalToys object for easier CSV handling"},"content":{"rendered":"

With service build 569 of PrimalScript 2007 we added a COM object that makes it easier to deal with CSV (comma separated values) data and\/or files.<\/p>\n

While browsing through posts at ScriptingAnswers.com and some of Microsoft’s scripting related newsgroups I couldn’t help but notice that questions regarding CSV keep coming up.<\/p>\n

I mentioned this to one of our engineers, Stephen Poon, and he created this object that can edit and display CSV files really easily.<\/p>\n

The following script is a PowerShell sample, a VBScript sample is included with PrimalScript 2007 (any edition) and the free PrimalToys download at our Free Tools Site<\/a><\/p>\n

$CSVEdit = New-Object -comObject “SAPIEN.CSVEditor”
\n$CSVEdit.FirstRowColumnNames = $True
\n$CSVEdit.DataStartRow = 1
\n$CSVEdit.ReadOnly = $True
\n$CSVEdit.Title = “Current Processes Summary”
\n$CSVEdit.Label=”Processes:” #Text Label for the Grid<\/p>\n

get-process | Export-Csv “C:\\Temp\\process.csv”
\n$CSVEdit.FileName = “C:\\Temp\\process.csv”
\n$CSVEdit.LoadFile()
\n$CSVEdit.ShowDialog()<\/p>\n

Running this will produce this dialog:<\/p>\n

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

The object includes a number of methods to insert, remove, extract columns rows or fields with or without displaying the UI.<\/p>\n

Check it out and head over to our Free Tools forum at
\nhttp:\/\/support.sapien.com\/forum\/forum_topics.asp?FID=10<\/a>
\nand let us know what you think and if\u00a0 there is anything we should add.<\/p>\n","protected":false},"excerpt":{"rendered":"

With service build 569 of PrimalScript 2007 we added a COM object that makes it easier to deal with CSV (comma separated values) data and\/or files. While browsing through posts at ScriptingAnswers.com and some of Microsoft’s scripting related newsgroups I couldn’t help but notice that questions regarding CSV keep coming up. I mentioned this to […]<\/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":[21,24,25],"tags":[28,37,273,191,57,996],"class_list":["post-584","post","type-post","status-publish","format-standard","hentry","category-software-news","category-vbscript","category-windows-powershell","tag-powershell","tag-primalscript","tag-primaltoys","tag-sapien","tag-scripting","tag-vbscript"],"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