Example #1
0
        /// <summary>
        /// Process a set of CSV lines
        /// </summary>
        /// <param name="lines"></param>
        private void ReadCsv(List <string> lines)
        {
            var separator = new char[] { ',' };

            // First row is column headers
            string columnHeaderLine = lines[0];

            string[] fileColHeaders = columnHeaderLine.Trim().Split(separator);
            _columnNames.Clear();

            int columnPosition = 0;

            // Store the ordinal position of each column
            foreach (var columnHeader in fileColHeaders)
            {
                _columnNames.Add(columnHeader, columnPosition++);
            }

            // Extract all the data
            for (int lineIndex = 1 /* Skip first */; lineIndex < lines.Count; lineIndex++)
            {
                if (string.IsNullOrEmpty(lines[lineIndex]))
                {
                    continue;
                }

                var     values   = new List <string>(lines[lineIndex].Trim().Split(separator));
                CsvLine nextLine = new CsvLine(values);
                _rows.Add(nextLine);
            }
        }
Example #2
0
        /// <summary>
        /// Process a set of CSV lines
        /// </summary>
        /// <param name="lines"></param>
        private void ReadCsv(List<string> lines)
        {
            var separator = new char[] { ',' };

            // First row is column headers
            string columnHeaderLine = lines[0];
            string[] fileColHeaders = columnHeaderLine.Trim().Split(separator);
            _columnNames.Clear();

            int columnPosition = 0;

            // Store the ordinal position of each column
            foreach (var columnHeader in fileColHeaders)
            {
                _columnNames.Add(columnHeader, columnPosition++);
            }

            // Extract all the data
            for (int lineIndex = 1 /* Skip first */; lineIndex < lines.Count; lineIndex++)
            {
                if (string.IsNullOrEmpty(lines[lineIndex]))
                {
                    continue;
                }

                var values = new List<string>(lines[lineIndex].Trim().Split(separator));
                CsvLine nextLine = new CsvLine(values);
                _rows.Add(nextLine);
            }
        }