// Distinct not working with LINQ to Objects

// see: https://stackoverflow.com/a/1365771/1016343

using System;

using System.Linq;

using System.Collections.Generic;

​

public class Program

{

    public static void Main()

    {

        var fileName = "2021-11-22_MB US Equity Checklist V8 v1_8900_22112021.zip";

        string reportingAccountId = fileName.Substring(fileName.IndexOf('_') + 1);

        reportingAccountId = reportingAccountId.Substring(reportingAccountId.IndexOf('_') + 1, reportingAccountId.LastIndexOf('_') - reportingAccountId.IndexOf('_') - 1);

        Console.WriteLine("FileDate: " + fileName.Substring( 0, fileName.IndexOf( "_" )));

        Console.WriteLine("ReportingAccountId: " + reportingAccountId);

        return;

    }

}