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.
You’re sabotaging your output with that format-table.
You need the Big Book of Powershell Gotchas.
Don - we need a sidebar menu with a link to that.
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.