PowerQuery - Text.BetweenDelimiters with StartDelimiter from list (ie. multiple)

JoakimHGjerde 

That's better with small sample, but let me try as I understood you. As a basis I'd take slightly modified function suggested by Ingeborg here Improved Text.SplitAny - function for Power BI and Power Query – The BIccountant

(string as text, separator as any) =>

let

    ListFunction = List.Accumulate(
        separator, 
        {string}, 
        (state, current) => 
        [   DoForEveryItemInTheList = List.Transform(state, each Text.Split(_, current)),
            FlattenNestedList = List.Combine(DoForEveryItemInTheList),
            RemoveEmpties = List.Select(FlattenNestedList, each _<>"" and _<>" ")
        ][RemoveEmpties]
    )
in
    ListFunction

Assuming any of "first" delimiters is always paired with "second" delimiter and end of the text we consider as "second" delimiter, transition from left to right here

could be done as

let
    firstDelims = {"ABC", "XYZ"},
    secondDelim = "/>",
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Added Custom" = Table.AddColumn(
        Source,
        "Custom",
        each
            List.Transform(
                List.FindText(
                    fnSplitText([A] & secondDelim,firstDelims),
                    secondDelim
                ),
                each
                    Text.Start(_, Text.PositionOf(_,secondDelim) )
            )
    ),
    NumberOfDelims = Table.AddColumn(
        #"Added Custom",
        "CountDelims",
        each List.Count([Custom])
    ),
    maxNumberOfDelims = List.Max(NumberOfDelims[CountDelims]),
    ColNames = List.Transform({1..maxNumberOfDelims}, each "Col " & Text.From(_) ),
    #"Extracted Values" = Table.TransformColumns(
        #"Added Custom",
        {"Custom",
         each
            Text.Combine(
                List.Transform(_, Text.From),
                ";"
            ),
         type text
        }
    ),
    #"Split Column by Delimiter" = Table.SplitColumn(
        #"Extracted Values",
        "Custom",
        Splitter.SplitTextByDelimiter(";", QuoteStyle.Csv),
        ColNames),
    #"Removed Columns" = Table.RemoveColumns(#"Split Column by Delimiter",{"A"})
in
    #"Removed Columns"

This module also could be converted to function.