Power Query - Split folder path with different structure into same columns

Zdenek_Moravec 

Slightly different variant (without transition from letter to number), but with same assumption we have only 4 parts and only second one (country) could be missed.

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Exclude Drive" = Table.AddColumn(
        Source, "path",
        each Text.AfterDelimiter([FileName], ":\"),
        type text
    ),
    #"Get Region" = Table.SplitColumn(
        #"Exclude Drive", "path",
        Splitter.SplitTextByEachDelimiter({"\"}, QuoteStyle.Csv, false),
        {"Region", "Txt"}
    ),
    #"Get File" = Table.SplitColumn(
        #"Get Region", "Txt",
        Splitter.SplitTextByEachDelimiter({"\"}, QuoteStyle.Csv, true),
        {"Txt", "File"}
    ),
    #"Get Country" = Table.AddColumn(
        #"Get File", "Country",
        each Text.BeforeDelimiter([Txt], "\", {0, RelativePosition.FromEnd}),
        type text
    ),
    #"Get Year" = Table.AddColumn(
        #"Get Country", "Year",
        each Text.AfterDelimiter([Txt], "\", {0, RelativePosition.FromEnd}),
        type text
    ),
    #"Keep Final" = Table.SelectColumns(
        #"Get Year",
        {"Region", "Country", "Year", "File"}
    )
in
    #"Keep Final"