Custom Delimiters ?

Hi

I have an query that run against SQL Server and returns a DataSet, I can
output the results to a csv file using,

$Results.tables[0] | Export-Csv ("c:\test.csv")

Some of the columns have dollar amounts e. Jim, money, $1,400 and that is
interpreted incorrectly in excel. Is there a way to specify an alternative
delimiter like | a pipe, so that it appears as Jim| money| $1,4000 with the
$1,400 intact ?

Thanks.

dm_14 wrote: As for export-csv, v2 CTP2's export-csv now has a new -delimiter tab
which allows for using something other than "," to seperate stuff.

So this would work:
PSHv2 CTP2> $results.tables[0]|export-csv -delimiter "|" c:\test.csv

Willing to try CTP2 on a non-production machine? If not, there should
be another method...

Marco

--
Microsoft MVP - Windows PowerShell
http://www.microsoft.com/mvp

PowerGadgets MVP
http://www.powergadgets.com/mvp

Blog:
http://marcoshaw.blogspot.com

Yes, the Windows data parsing tool,
IIS's Microsoft's (local or remote) data
parser, Log Parser 2.2 (with built-in
Microsoft ChartSpace chart maker)
can do what one wants!

-o:tsv -oSeparator:"|"

PowerShell users use Log Parser
just like PowerShell users use IE,
ChartSpace, Excel, Word, NetStat.exe
or MSBuild.exe or WinRM and so on!

Notice: IIS does not need to be running
or installed in order to use Log Parser
for either data parsing or chart making.

Search the Internet
(and this newsgroup)
for usage of:

Microsoft's Log Parser
command line usage,
or fully script enabled
either in COM or .NET
(from the IIS group)

Remember, ever since PowerShell
added HTTP / HTTPS usage (like IIS)
Log Parser became PowerShell's data
parser (like Log Parser is for IIS) too!

Hi Flowering Weeds,

Could you please provide a short working example ?

Thanks.

"Flowering Weeds" wrote: