2014 May 25, 1:46
Additional considerations beyond the naïve implementation of a CSV parser.
2013 Aug 15, 10:04
PowerShell nicely includes ConvertTo-CSV and ConvertFrom-CSV which allow you to serialize and deserialize your PowerShell objects to and from CSV. Unfortunately the CSV produced by ConvertTo-CSV is
not easily opened by Excel which expects by default different sets of delimiters and such. Looking online you'll find folks who recommend using automation via COM to create a new Excel instance and
copy over the data in that fashion. This turns out to be very slow and impractical if you have large sets of data. However you can use automation to open CSV files with not the default set of
delimiters. So the following isn't the best but it gets Excel to open a CSV file produced via ConvertTo-CSV and is faster than the other options:
$excel = New-Object -ComObject Excel.Application
$xlDelimited=1 # 1 = delimited, 2 = fixed width
$xlTextQualifierDoubleQuote=1 # 1= doublt quote, -4142 = no delim, 2 = single quote
$consequitiveDelim = $False;
$tabDelim = $False;
$semicolonDelim = $False;
$commaDelim = $True;
See Workbooks.OpenText documentation
for more information.
2012 Aug 28, 4:38
When they went to the Moon, they received the same per diem compensation as they would have for being away from base in Bakersfield: eight dollars a day, before various deductions (like for
accommodation, because the government was providing the bed in the spaceship).
Apollo 11’s Astronauts Received an $8
Per Diem for the Mission to the Moon
The astronauts of Apollo 11: Intrepid explorers. Inspirational heroes. Government employees.
Read more. [Image:
2011 Apr 29, 3:55
This memo defines URI fragment identifiers for text/csv MIME entities. These fragment identifiers make it possible to refer to parts of a text/csv MIME entity, identified by cell, row, column, or
2008 Jul 22, 11:09
Radiohead released the data points from their latest video as CSV free for us to use, so expect odd CG videos featuring Thom York.
2007 Jan 30, 2:41
I was unaware of it but there's a standard for CSV files and it defines how to encode quotes, commas, and newlines inside of records.
2006 Apr 10, 1:35