Use PowerShell to Append CSV Files Easily

re: Use PowerShell to Append CSV Files Easily

Eric B. — Wed, 18 Jul 2012 01:17:57 GMT

When I try this, the first csv is imported and then there is a long blank space under it and nothing else. The second csv does not show as in your example. Any ideas what could be causing this?

I'm doing this on a Win 7 SP1 machine. Powershell 2.0

Thanks

re: Use PowerShell to Append CSV Files Easily

Klaus Schulte — Thu, 03 Nov 2011 15:26:30 GMT

Hi Ed,

this is a really easy way to accomplish the task!

In fact the quotation marks are sometimes unwanted and the best solution would be an additional switch parameter to export-csv that supresses them!

But of course we can get around it with notepad or a little code ...

Klaus

re: Use PowerShell to Append CSV Files Easily

Ed Wilson — Mon, 31 Oct 2011 17:14:14 GMT

@Jeffrey S. Patton, you are right that I could have used code to replace the quotation mark with nothing, but it is a lot more work for this particular scenario. I do not believe your code below will actually work, but it is definately on the right track. I came up with the following:

(Get-Content C:\fso\UsersConsolidated.csv) | % {$_ -replace "`"", "" }

But this is only half of the story. Because next I need to write this back to a file.

re: Use PowerShell to Append CSV Files Easily

Jeffrey S. Patton — Mon, 31 Oct 2011 14:15:23 GMT

Nice article! But, why use notepad?

?.Replace("`"","")