Capture Performance Counter Data and Write to SQL Server

re: Capture Performance Counter Data and Write to SQL Server

Ed Wilson — Sun, 07 Aug 2011 21:29:15 GMT

@Sandeep you are welcome. I have used -replace in the past to remove the extra double quotes from excel ... But like you, I have pretty much quit using Excel for CSV due to this problem.

re: Capture Performance Counter Data and Write to SQL Server

sandeep — Sat, 06 Aug 2011 10:34:02 GMT

Thank you for the tip ... I love it. The double-quote thing in Excel is very annoying, and I have just about quit using it for viewing CSV types of data due to that problem. But, yeah, I completely missed the "Text qualifier" option. Sweet!!!

re: Capture Performance Counter Data and Write to SQL Server

ed wilson — Wed, 27 Jul 2011 15:26:02 GMT

@Chad

re: Capture Performance Counter Data and Write to SQL Server

Chad Miller — Wed, 27 Jul 2011 14:48:40 GMT

Ed,

If you use Import Wizard you'll want to change the "Text qualifier" from <none> to "

This way you'll avoid quotes in your data as seen in your screenshot. You'll also notice Excel defaults double-quotes as being a Text qualifier or also called a text delimiter so no modification necessary when viewing in Excel.