using System;

using System.Text.RegularExpressions;

using System.Collections.Generic;

​

namespace Multiline_Email_Test

{

    /// <summary>

    /// Console app to test the reading of the multiline email.

    /// If successful readback is shown we could import to SQL Server.

    /// </summary>

    public class Program

    {

        public static void Main()

        {

            string email = @"NOTIFICATION OF MOVEMENT STARTING IN AUGUST

​

Consignor Package ID                              Local Reference Number

-------------------                              ----------------------

GRLK123450012                                         123456

​

Place Of dispatch                                Guarantor type code

-----------------                                -------------------

GR00001234567                                          1

​

Consignee Package ID                              Guarantor details

-----------------                                -------------------

RR001239E0070

​

Place Of delivery                                Date of dispatch DD MM YYYY

-----------------                                ---------------------------

FR001379E0570                                    21 03 2019

​

                                                 Time of dispatch

                                                 ----------------

                                                 08:29

​

                                                 Vehicle registration number

                                                 ---------------------------

                                                 XXBB12345678

​

 Item number   Package Product CN CodeCode    Quantity       Brand

 -----------   -------------------------     --------       -----

 Line 1 of 2   B000           22040009       7603.200       Guinness DIC    440ml CAN 06X04 MDCES

 Line 2 of 2   B000           22040009       14636.160      Guinness DIC    440ml CAN 06X04 MDCES

​

​

​

​

​

";

            var dict = new Dictionary<string, string>();

            try

            {

                var lines = email.Split(Environment.NewLine.ToCharArray(), StringSplitOptions.RemoveEmptyEntries);

                int starts = 0, end = 0, length = 0;

                while (!lines[starts + 1].StartsWith("-"))

                    starts++;

                for (int i = starts + 1; i < lines.Length; i += 3)

                {

                    var mc = Regex.Matches(lines[i], @"(?:^| )-");

                    foreach (Match m in mc)

                    {

                        int start = m.Value.StartsWith(" ") ? m.Index + 1 : m.Index;

                        end = start;

                        while (lines[i][end++] == '-' && end < lines[i].Length)

                            ;

                        length = Math.Min(end - start, lines[i - 1].Length - start);

                        string key = length > 0 ? lines[i - 1].Substring(start, length).Trim() : "";

                        end = start;

                        while (lines[i][end++] == '-' && end < lines[i].Length)

                            ;

                        length = Math.Min(end - start, lines[i + 1].Length - start);

                        string value = length > 0 ? lines[i + 1].Substring(start, length).Trim() : "";

                        dict.Add(key, value);

                    }

                }

            }

            catch (Exception ex)

            {

                throw new Exception(ex.ToString());

            }

​

            foreach (var x in dict)

                Console.WriteLine("{0} : {1}", x.Key, x.Value);

        }

    }

}