Esempio n. 1
0
        public static void Compare(String handsOnFileName, String exportedFileName, String missingFileName, String newFileName)
        {
            ExtendedCSV extended = new ExtendedCSV(
                new FileStream(handsOnFileName, FileMode.Open), new List <string>()
            {
                "WASP"
            }
                );

            CSV other = new CSV(new FileStream(exportedFileName, FileMode.Open));

            extended.GetMissingRowsFrom(other).Save(missingFileName);
            extended.GetExtraRowsFrom(other).Save(newFileName);
        }
Esempio n. 2
0
        public static void Combine()
        {
            List <String> files =
                Directory.EnumerateFiles("/Users/jcox/Documents/toCombine/").Where(
                    fn => fn.EndsWith(".csv", StringComparison.InvariantCultureIgnoreCase)).ToList();

            CSV output = new CSV();

            foreach (string fileName in files)
            {
                CSV toAdd = new CSV(new FileStream(fileName, FileMode.Open));
                output.Add(toAdd);
            }

            output.Save("/Users/jcox/Documents/combined.csv");
        }
Esempio n. 3
0
        /// <summary>
        /// Query this table and find all rows that match a set of regular expressions.
        /// Use this to find all rows where a data fits a particular set of regular expressions.
        /// for example, find all rows in a contact list where the Phone Number has a 540 area code
        /// and the street address is in a particular town.
        /// </summary>
        /// <param name="primaryKey"></param>
        /// <returns></returns>
        public CSV this[Dictionary <string, Regex> primaryKey]
        {
            get
            {
                CSV output = new CSV();
                foreach (Dictionary <String, String> row in this)
                {
                    foreach (string key in primaryKey.Keys)
                    {
                        if (!row.ContainsKey(key) || !primaryKey[key].IsMatch(row[key]))
                        {
                            continue;
                        }
                    }

                    output.Add(row);
                }

                return(output);
            }
        }
        public CSV PullRowsMatchingPrimaryKeysWith(CSV other)
        {
            CSV output = new CSV();

            foreach (Dictionary <String, String> row in other.Data)
            {
                try
                {
                    output.Add(this.Find(row));
                }
                catch (KeyNotFoundException)
                {
                    continue;
                }
                catch (InvalidDataException)
                {
                    continue;
                }
            }

            return(output);
        }
        /// <summary>
        /// Gets the extra rows from this csv which are not present in the other csv.
        /// </summary>
        /// <returns>The extra rows from.</returns>
        /// <param name="other">Other.</param>
        public CSV GetExtraRowsFrom(CSV other)
        {
            CSV output = new CSV();

            foreach (Dictionary <String, String> row in this.Data)
            {
                bool found = false;
                foreach (Dictionary <string, string> checkRow in other.Data)
                {
                    if (CompareUniqueFields(checkRow, row))
                    {
                        found = true;
                        break;
                    }
                }

                if (!found)
                {
                    output.Add(row);
                }
            }

            return(output);
        }
 /// <summary>
 /// Initializes a new instance of the <see cref="T:CSVDataManipulation.ExtendedCSV"/> class.
 /// </summary>
 /// <param name="toExtend">To extend.</param>
 /// <param name="uidfields">Uidfields.</param>
 public ExtendedCSV(CSV toExtend, List <string> uidfields) : base(toExtend.Data)
 {
     this.UniqueFields = uidfields;
 }
Esempio n. 7
0
        public static void Flatten()
        {
            List <String> files = Directory.EnumerateFiles(String.Format("/Users/{0}/Documents/toFlatten/", Environment.UserName)).ToList();

            if (!Directory.Exists(String.Format("/Users/{0}/Documents/flattened", Environment.UserName)))
            {
                Directory.CreateDirectory(String.Format("/Users/{0}/Documents/flattened", Environment.UserName));
            }

            List <String> uniqueFields = new List <string>();

            if (File.Exists(String.Format("/Users/{0}/Documents/toFlatten/.flatten.conf", Environment.UserName)))
            {
                StreamReader reader =
                    new StreamReader(
                        new FileStream(
                            String.Format("/Users/{0}/Documents/toFlatten/.flatten.conf", Environment.UserName),
                            FileMode.Open));

                String fields = reader.ReadLine();
                uniqueFields.AddRange(fields.Split('\t'));
            }
            else
            {
                // ask the user.
                Console.WriteLine("What are the unique fields?  [Enter one at a time.  '*' to End.");
                String field = "";
                while (true)
                {
                    Console.Write(">> ");
                    field = Console.ReadLine();
                    if (field.Equals("*"))
                    {
                        break;
                    }
                    else
                    {
                        uniqueFields.Add(field);
                    }
                }
            }

            foreach (string fileName in files)
            {
                if (!fileName.EndsWith(".csv", StringComparison.CurrentCultureIgnoreCase))
                {
                    continue;
                }
                Console.WriteLine(fileName);
                FileStream fileStream = new FileStream(fileName, FileMode.Open);

                ExtendedCSV extendedCSV = new ExtendedCSV(fileStream, uniqueFields)
                {
                    ConflictRule = new YesBeatsNoConflictRule()
                    {
                        NextRule = new UserResolveConflictRule()
                    }
                };

                CSV    output      = extendedCSV.FlattenRows();
                string outfilename = fileName.Replace("toFlatten", "flattened");
                output.Save(outfilename);
                Console.WriteLine("Flattened: {0}", outfilename);
            }

            Console.WriteLine("Done!");
            Console.ReadKey();
        }