C#

var r = File.ReadAllLines(path)
            .Select(line => line.Split(' '))
            .Select(arr => new
                {
                    Column0 = Int32.Parse(arr[0]),
                    Column1 = Int32.Parse(arr[1])
                    // etc
                })
            .ToArray();
int[] column0 = r.Select(x => x.Column0).ToArray();
int[] column1 = r.Select(x => x.Column1).ToArray();

for (int i=0; i<=column1.Count - 2;i++)
{
  float slope = (column1[i+1] - column1[i])/(column0[i+1] - column0[i])
}

private string[] SubDirNames = new string[]
                                            {
                                                "Cancel",
                                                "ED",
                                                "UI",
                                                "RCS"
                                            };

private List<string> GetSubDirectoryPaths(DirectoryInfo rootDir)
{
    List<string> subDirs = new List<string>();

    foreach (string subDirName in SubDirNames)
    {
        DirectoryInfo[] dirs = rootDir.GetDirectories(subDirName);
        if (dirs.Length > 0)
        {
            subDirs.Add(dirs[0].FullName);
        }
        else
        {
            string path = Path.Combine(rootDir.FullName, subDirName);
            Directory.CreateDirectory(path);
            logging.Error("The location " + path + " does not exist for documents. ");
        }
    }
    return subDirs;
}

private string[] GetFiles(string subDir)
{
    return (from path in Directory.GetFiles(subDir)
            let name = Path.GetFileName(path)
            where name.EndsWith(".pdf") ||
            name.EndsWith(".xlsx") ||
            name.EndsWith(".xls")
            select path).ToArray();
}

public string addNewPKG()
{
    try
    {
        string packageId = "";

        DateTime myDateTime = DateTime.Now.AddMonths(-1);
        string fromDate = "_" + myDateTime.ToString("MMM").ToUpper() + " _" + myDateTime.ToString("yyyy");
        string rootDirPath = Path.Combine(ConfigurationSettings.AppSettings["tLocation"], fromDate);

        DirectoryInfo rootDir = new DirectoryInfo(rootDirPath);
        if (!rootDir.Exists)
        {
            rootDir.Create();
            logging.Error("The location " + rootDirPath + " does not exist for documents. ");
            return packageId;
        }
        else
        {
            List<string> subDirPaths = GetSubDirectoryPaths(rootDir);

            foreach (string subDir in subDirPaths)
            {
                string[] RVWFiles = GetFiles(subDir);

                if (RVWFiles.Length > 0)
                {
                    foreach (string RFile in RVWFiles)
                    {
                        string orgnizationName = "";
                        string contactName = "";
                        string fileNameWithExtension = Path.GetFileName(RFile);
                        string fileName = Path.GetFileNameWithoutExtension(RFile);
                        string Original_location = subDir;

                        string[] names = fileName.Split('_');
                        orgnizationName = names[0].TrimEnd();
                        contactName = names[1].TrimStart();


                        string strOrgnizationName = orgnizationName;

                        string[] items = contactName.TrimEnd().Split(' ');
                        string surname = items[items.Length - 1];
                        //--here does the processing that is required--

                        // you cannot return here, you are still in the loop!
                        //return null;
                    } //closing bracket for  foreach (String RFile in RFiles)
                }
                else
                {
                    logging.Info("packageId: " + packageId + " the location " + subDir + " does not contain any documents. ");
                    return packageId;
                }
            }
        }
    }
    catch (Exception e)
    {
        logging.Error("Error Processing --> " + e.Message);
        logging.Error("************* Stack Trace *******************");
        logging.Error(e.StackTrace);
        // throwing an exception on exception is pointless; either catch the exception and handle it safely or let the compiler to throw the exception.
        //throw new Exception(e.Message);
        return packageId;
    }
    return null;
}

zebra88 wrote:

Can i make this field look like as ..... rather than numbers?

static void SumNumbersinDate()
        {
            //http://www.codeproject.com/Messages/4513781/I-have-string-1999220-how-to-parse.aspx
            string theDate = "19881205";
            char[] dateLetters = theDate.ToCharArray();
            int[] dateNumbers = new int[theDate.Length];
            int sum = 0;
            for (int ind = 0; ind < theDate.Length; ind++)
            {
                Console.WriteLine("Current Total: " + sum.ToString());
                dateNumbers[ind] = int.Parse(dateLetters[ind].ToString());
                Console.WriteLine("Adding: " + dateNumbers[ind].ToString());
                sum += dateNumbers[ind];
                Console.WriteLine("New Total: " + sum.ToString());
            }
            Console.WriteLine("The sum of the numbers is: " + sum.ToString());
            Console.WriteLine("Press any key to close the demo...");
            Console.ReadKey(true);
        }