corey lawson (12/15/2008)

---

That's a good article, except for a couple of things.

Why do people still literally use commas as field separators (unless they have to, because the tool/function/utility doesn't support anything else)? Gaaaahhh! The example even uses the field separator parameter...

And, well, it's PowerShell. I'd rather do this stuff in INTERCAL, but to each their own...

Of course, BCP does this stuff as well...

thermanson (12/16/2008)

---

I have found that TAB seperated files seem to cause the least number of problems. Unfortunately TABs aren't always possible, if you have to work with a file created by a mainframe or a file that you receive by FTP then TABs probably aren't an option.

It is possible to Bulk Insert a file starting at the "nth" row with out creating a format file. Simply use the firstrow option.

Bulk Insert #temp
From 'c:\data.txt'
With (firstrow = 2)

David Ly (12/16/2008)

---

when i ran:

./diskusage.ps1 sydw1255|export-CSV -path ./diskusage.csv -noTypeInformat

I get this error:

An empty pipe element is not permitted.
At F:\Working Folders\PowerShell\diskusage.ps1:4 char:2

David Ly (12/16/2008)

---

when i ran:

./diskusage.ps1 sydw1255|export-CSV -path ./diskusage.csv -noTypeInformat

I get this error:

An empty pipe element is not permitted.
At F:\Working Folders\PowerShell\diskusage.ps1:4 char:2