Vista - export results to tab-delimited file

Greetings,

I am running this command which does a nice job exporting everything to
a csv file:

Get-MailboxStatistics -Identity trmbx | select-object
LegacyDN,LastLoggedOnUserAccount,TotalItemSize,ItemCount,LastLogonTime,StorageLimitStatus,DatabaseName
| Export-Csv -Path trmbx.csv

Is there a simple way to export the same info into a tab-delimited file?

Thanks

The answer is probably no in the immediate future. In PowerShell v2
export-csv has a -delimiter parameter that you could use for this

I guess you are using v1 on Exchange 2007 though.

--
Richard Siddaway
All scripts are supplied "as is" and with no warranty
PowerShell MVP
Blog: http://richardsiddaway.spaces.live.com/
PowerShell User Group: http://www.get-psuguk.org.uk


"sneaky hamster" wrote:

Thanks!

Yes correct - v1 on Exchange 2007.

RichS [MVP] wrote:

Here's a quick workaround for V1:

(gc .\data.csv | %{$_ -replace '","',"`"`t`""}) | sc .\data.csv

"sneaky hamster" <sneaky.hamster@xxxxxx> wrote in message
news:ez4eCKG9JHA.4376@xxxxxx

Hello sneaky,

Not currently, as Rich mentioned, but you can convert the file

Get-MailboxStatistics -Identity trmbx | Select-Object LegacyDN,LastLoggedOnUserAccount,TotalItemSize,ItemCount,LastLogonTime,StorageLimitStatus,DatabaseName
| Export-Csv -Path trmbx.tsv -NoTypeInformation
$string = Get-Content trmbx.tsv |out-string
$string.Replace(",","`t") |out-file c:\trmbx.tsv

Mmm since this is the year of data parsing
and charting (and yes Regex is also included)
then FYI
Remember, Windows PowerShell
is a Windows-based automation tool,
meant to pass "data"
from tool to tool, to tool,
until output (or whatever)!

So perhaps (like so many IT Pros) automate
a data parser tool within powershell.exe!

PS > LogParser.exe -h -o:tsv

Output format: TSV (TSV Output Format)
Formats fields as tab- or space- separated list of values

+Exchange +"Log Parser" - Bing
http://www.bing.com/search?q=%2BExch...2Log+Parser%22

+"tab" +"Log Parser" - Bing
http://www.bing.com/search?q=%2B%22t...2Log+Parser%22

And surely after all these years,
any PowerShell user can help
one automate Log Parser too!

As always enjoy the automation
of tools within the Windows-based,
..NET aware, WPF accessible,
admin's automation tool,
powershell.exe!

Thank you all!


sneaky hamster wrote: