Export-CSV how to use column separator

Question

I have the script below that works just fine, but i need to use the pipe separator as a column separator, help :

$enddate = (Get-Date).tostring("yyyyMMdd")
$AttachmentPath6 = 'D:\PerfTeam_Queries\' + $enddate + '_Interfaces.csv'
$QueryFmt6= "SELECT NodeID,InterfaceID,InterfaceName,InterfaceType,InterfaceTypeDescription,InterfaceSpeed,InterfaceMTU,InBandwidth,OutBandwidth,FullName FROM Interfaces; "
Invoke-Sqlcmd -ServerInstance localhost -Database NetPerfMon -Query $QueryFmt6 | Export-CSV $AttachmentPath6

Mattgb · Accepted Answer · 2014-09-18 16:25:18Z

1

You need to use the parameter -s and then I would use quotes and put the pipe into those quotes i.e.

sqlcmd -S localhost -d NetPerfMon -Q $QueryFmt6 -s "|" -o $AttachmentPath6

As Per Matt's comment :

Invoke-Sqlcmd -ServerInstance localhost -Database NetPerfMon -Query $QueryFmt6 | Export-CSV -Delimiter '|' $AttachmentPath6

edited Sep 18, 2014 at 16:25

answered Sep 18, 2014 at 15:26

Mattgb

4283 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Gabriel Gonzales Over a year ago

is there a way to use Invoke-Sqlcmd ?

Mattgb Over a year ago

msdn.microsoft.com/en-us/library/cc281720.aspx I doubt that this option is actually available using invoke-sqlcmd, you could try wrapping the pipe in quotes but as you have specified export-csv then I suspect that you will always get a comma delimited output.

Matt Over a year ago

Just because of that last comment i want to chime in here.@GabrielGonzales Is it the output created by Export-CSV that you want to control to column separator? Export-Csv $AttachmentPath6 -Delimiter "|"

Mattgb Over a year ago

@Matt I was just about to put that in :)

Collectives™ on Stack Overflow

Export-CSV how to use column separator

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related