exporting fixed length This topic contains 2 replies, has 3 voices, and was last updated by Don Jones 5 years, 2 months ago. Author Posts May 5, 2013 at 11:05 am #4026 conanParticipant 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 #4031 Rob CampbellParticipant 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 #4064 Don JonesKeymaster 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. Author Posts You must be logged in to reply to this topic.