Hmmm ... usually you don't need if you do it right. And you don't need to remove the header as well. Powershell is able to deal with both, headers and quotes, accordingly.
What would you like to do with the data? To what kind of table would you like to import them?
There are probably better ways to do whatever you are doing, but this gives you tab delimited output without quotes. If you are looking for a fixed length solution, see Amit’s post above and take a look at string formatting help to understand what it is doing. Here’s a sample.
You might show a little bit of the code you’re using. There might be other problems with it. Sometimes you try to solve an issue on the left hand side but actually it is on the right hand side … you know what I mean!?
You mentioned needing to update a table, but without more info, it’s hard to suggest a better solution. Is it a spreadsheet? Database table/what type? You are asking for the data in an odd format that shouldn’t be required in most cases. If the format required is application specific, then there might not be a better way, but we can’t suggest one without knowing more.
Look at Amit’s post, there was a small error where he left one variable/placeholder out in the format string. You need four columns and the command only had 3 listed.
