using System; using System.Linq; public class Test { public static void Main() { var s = new string[] { "a0|a1|a2|a3|a4|a5|a6|a7|a8|a9|a10|a11|a12", "b0|b1|b2|b3|b4|b5|b6|b7|b8|b9|b10|b11|b12" }; var result = s.Select(a => a.Split(new[] { '|' }, StringSplitOptions.None)) .Select(a => new { Column1 = a[2].Trim(), Column2 = a[5].Trim(), Column3 = a[6].Trim(), Column4 = a[11].Trim() }); foreach (var entry in result) Console.WriteLine(entry.Column1 + ", " + entry.Column2 + ", " + entry.Column3 + ", " + entry.Column4); } }