Parse Csv Or Text Format - CSharp System.IO

CSharp examples for System.IO:CSV File

  1. HOME
  2. CSharp
  3. System.IO
  4. CSV File

Description

Parse Csv Or Text Format

Demo Code


using System.IO;/*from  www .  j  a  v  a 2s  .  com*/
using System.Windows;
using System.Diagnostics;
using System.Text;
using System.Linq;
using System.Collections.Generic;
using System;

public class Main{
        private static string[] ParseCsvOrTextFormat(string value, bool isCSV)
        {
            List<string> outputList = new List<string>();

            char separator = isCSV ? ',' : '\t';
            int startIndex = 0;
            int endIndex = 0;

            for (int i = 0; i < value.Length; i++)
            {
                char ch = value[i];
                if (ch == separator)
                {
                    outputList.Add(value.Substring(startIndex, endIndex - startIndex));

                    startIndex = endIndex + 1;
                    endIndex = startIndex;
                }
                else if (ch == '\"' && isCSV)
                {
                    // skip until the ending quotes
                    i++;
                    if (i >= value.Length)
                    {
                        throw new FormatException(string.Format("value: {0} had a format exception", value));
                    }
                    char tempCh = value[i];
                    while (tempCh != '\"' && i < value.Length)
                        i++;

                    endIndex = i;
                }
                else if (i + 1 == value.Length)
                {
                    // add the last value
                    outputList.Add(value.Substring(startIndex));
                    break;
                }
                else
                {
                    endIndex++;
                }
            }

            return outputList.ToArray();
        }
}

Related Tutorials