PQ Split by Second Delimiter

[cr731]

I have a column containing delimited values and I need to split them by the second instance of the delimiter, ignoring any other instances of the delimiter. The delimiter is "-" (hyphen) For example,

One-Two-Three-Four
One-Two-ThreeFour

Needs to be split into

One-Two	Three-Four
One-Two	ThreeFour

<tbody>
</tbody>

Is there a good way to do this?

Thanks

 

[MarcelBeug]

Recently, 3 new functions were added to Power Query to extract texts before/after/between delimiters.
If you have the correct version, this will work:

let
    Source = Table1,
    Part2 = Table.AddColumn(Source, "Part2", each Text.AfterDelimiter([Column1],"-",1)),
    Part1 = Table.TransformColumns(Part2, {{"Column1", each Text.BeforeDelimiter(_, "-",1)}})
    
in
    Part1

Each last argument "1" means the 2nd delimiter (0-based).