I often need to read and write files in delimited files from within a .Net Core application. It seems that there is no inbuilt parser for doing this so I wrote one.<\/p>\n
The code consists of a single static class \u201cDelimtedFile\u201d that has two methods, one to read a delimited file and one to write one.<\/p>\n
\r\nusing System;\r\nusing System.Collections.Generic;\r\nusing System.IO;\r\nusing System.Linq;\r\nusing System.Linq.Expressions;\r\nusing System.Text;\r\n\r\nnamespace ReadAndWriteDelimtedFiles\r\n{\r\n public static class DelimtedFile\r\n {\r\n \/\/\/ <summary>\r\n \/\/\/ Reads a delimited file into a List of strings lists.\r\n \/\/\/ <\/summary>\r\n \/\/\/ <param name="filePath">The path to the file<\/param>\r\n \/\/\/ <param name="delimter">The delimiter used \r\n \/\/\/ to parse the items within each line of the file.<\/param>\r\n \/\/\/ <returns><\/returns>\r\n public static List<List<string>> ReadDelimtedFile(string filePath, \r\n char delimter)\r\n {\r\n var lines = new List<List<string>>();\r\n\r\n var fileLines = File.ReadAllLines(filePath);\r\n\r\n foreach (var line in fileLines)\r\n {\r\n var lineList = new List<string>();\r\n lineList.AddRange(line.Split(delimter));\r\n lines.Add(lineList);\r\n }\r\n\r\n return lines;\r\n }\r\n\r\n \/\/\/ <summary>\r\n \/\/\/ Writes the data in linesList into a \r\n \/\/\/ output specificed by path using the delimiter.\r\n \/\/\/ If headerList is not null inlcudes the header \r\n \/\/\/ at the top of the file.\r\n \/\/\/ <\/summary>\r\n \/\/\/ <param name="path">The path to the file to \r\n \/\/\/ write the delimited file.<\/param>\r\n \/\/\/ <param name="linesList">The contents of the \r\n \/\/\/ file to write out<\/param>\r\n \/\/\/ <param name="headerList">The header line for \r\n \/\/\/ the file, if null no header is included<\/param>\r\n \/\/\/ <param name="delimiter">The delimiter for \r\n \/\/\/ the items in linesList<\/param>\r\n public static void WriteDelimtedFile(string path, \r\n List<List<string>> linesList, \r\n List<string> headerList,\r\n char delimiter)\r\n {\r\n var lines = new List<string>();\r\n\r\n if (headerList != null)\r\n {\r\n lines.Add(headerList.Aggregate((i, j) => i + delimiter + j));\r\n }\r\n\r\n lines.AddRange(linesList.Select(listString => \r\n listString.Aggregate((i, j) => i + delimiter + j)));\r\n\r\n File.WriteAllLines(path, lines.ToArray());\r\n }\r\n }\r\n}\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"I often need to read and write files in delimited files from within a .Net Core application. It seems that there is no inbuilt parser for doing this so I wrote one. The code consists of a single static class \u201cDelimtedFile\u201d that has two methods, one to read a delimited file and one to write one. using System; using System.Collections.Generic; using System.IO; using System.Linq; using System.Linq.Expressions; using System.Text; namespace ReadAndWriteDelimtedFiles { public static class DelimtedFile { \/\/\/ <summary> \/\/\/ Reads…<\/p>\n