Skip to main content

Posts

Showing posts from August, 2017

Adding Header Data to CSV Files

Don’t you just hate it when you get partial information?  With information systems, you would think that you would get everything you need.  It is like when I ask one of my Sailors why they are late and I have to ask a half dozen more questions before I get the full story. (Insert rolling eyes). A neat thing that I do to demonstrate to my advance PowerShell classes is how to make a GUI using SAPIEN PowerShell Studio.  Yes, I know. PowerShell was not supposed to be ran in a GUI.  Try asking a non-technical user to execute something at the command line.  I would rather visit the dentist.  Placing a pretty GUI on top of the code fools them into wanting to use it. For our stock application, We download information from Yahoo Finance.  Go ahead and execute the code below. $Sym = "Msft" $URL = "http://finance.yahoo.com/d/quotes.csv?s= $Sym &f=snl1ghjkvw4P2" Invoke-RestMethod -Uri $URL "Msft","Microsoft Corporation",72.58,