Databases
StackOverflow2013
Postsdbo
PO
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    text
    copied!<pre><code>using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Text.RegularExpressions; namespace StringParsingWithLinq { internal class Program { private static void Main(string[] args) { var inputs = new List&lt;string&gt; { "FirstName,LastName,Title,BirthDate,HireDate,City,Region", "Nancy,Davolio,Sales Representative,1948-12-08,1992-05-01,Seattle,WA", "Andrew,Fuller,\"Vice President, Sales\",1952-02-19,1992-08-14,Tacoma,WA", "Janet,Leverling,Sales Representative,1963-08-30,1992-04-01,Kirkland,WA", "Margaret,Peacock,Sales Representative,1937-09-19,1993-05-03,Redmond,WA", "Steven,Buchanan,Sales Manager,1955-03-04,1993-10-17,London,NULL", "Michael,Suyama,Sales Representative,1963-07-02,1993-10-17,London,NULL", "Robert,King,Sales Representative,1960-05-29,1994-01-02,London,NULL", "Laura,Callahan,Inside Sales Coordinator,1958-01-09,1994-03-05,Seattle,WA", "Anne,Dodsworth,Sales Representative,1966-01-27,1994-11-15,London,NULL" }; Console.Write(FixedWidthHelper.ReadLines(inputs) .ToFixedLengthString()); Console.ReadLine(); } #region Nested type: FixedWidthHelper public class FixedWidthHelper { private readonly Regex _csvRegex = new Regex(",(?=(?:[^\"]*\"[^\"]*\")*(?![^\"]*\"))"); private readonly List&lt;string[]&gt; _data = new List&lt;string[]&gt;(); private List&lt;int&gt; _fieldLen; public static FixedWidthHelper ReadLines(List&lt;string&gt; lines) { var fw = new FixedWidthHelper(); lines.ForEach(fw.AddDelimitedLine); return fw; } private void AddDelimitedLine(string line) { string[] fields = _csvRegex.Split(line); if (_fieldLen == null) _fieldLen = new List&lt;int&gt;(fields.Select(f =&gt; f.Length)); for (int i = 0; i &lt; fields.Length; i++) { if (fields[i].Length &gt; _fieldLen[i]) _fieldLen[i] = fields[i].Length; } _data.Add(fields); } public string ToFixedLengthString() { var sb = new StringBuilder(); foreach (var list in _data) { for (int i = 0; i &lt; list.Length; i++) { sb.Append(list[i].PadRight(_fieldLen[i] + 1, ' ')); } sb.AppendLine(); } return sb.ToString(); } } #endregion } } </code></pre> <p><img src="https://i.imgur.com/x0cxJ.png" alt="alt text"></p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload