Quoted CSV Output From Tab Delimited Data

Return to ClipboardFusion Macros

Description	Takes tab delimited data (including data copied from Excel), and converts it into a comma separated values (CSV) or comma delimited format where each field is surrounded by quotes. This helps in situations where each field in a CSV file needs to be quoted since saving a file as a CSV from Excel will only place quotes around fields that happen to have commas in them. There are no options in Excel to quote all output.
Language	C#
Minimum Version	3.3+
Created By	wooster11
Contributors	-
Date Created	Aug 19, 2014
Date Last Modified	6d ago

Macro Code

Copy

Select All

Toggle Line Wrapping

using System; public static class ClipboardFusionHelper { public static string ProcessText(string text) { System.Text.StringBuilder output = new System.Text.StringBuilder(); System.IO.StringReader sr = new System.IO.StringReader(text); string line = null; line = sr.ReadLine(); while (line != null) { string[] parts = line.Split('\t'); output.AppendFormat("{0}{1}{0}{2}", '"', String.Join("\",\"", parts), "\n"); line = sr.ReadLine(); } return output.ToString(); } }