Author Posts

May 5, 2013 at 11:05 am

Invoke-Sqlcmd -ServerInstance  MYPC -Database salesdatabase -Query usp_GetProductList  |  Format-TABLE-autosize  |Out-File C:\TEST.TXT

 

I am exporting a fixed lenght file.. Powershell is putting in a blank space between columns. I can't have that in my export file.

Thanks in advance.

Conan

May 5, 2013 at 3:46 pm

You're sabotaging your output with that format-table.

You need the Big Book of Powershell Gotchas.

https://powershell.org/books/the-big-book-of-powershell-gotchas-free/

 

Don – we need a sidebar menu with a link to that.

May 6, 2013 at 8:19 am

LOL.

Rob's right – Format-Table and the other Format cmdlets are intended to produce human-readable, formatted text. For a fixed-field output, you'll probably need to write a custom function to get really accurate output.