Power Query - how remove everything but XX-XX-XX from a string of text

Hello,
Is it possible to use Power Query to remove from a text string everything but the substrings that end with 4 digits starting either with 19XX or 20XX? For example, in the attached file, one of the cells in column B has the following string:

Quote
all, all radiators, dimensions 1, freightliner, freightliner-cascadia, freightliner-cascadia-2017, freightliner-cascadia-2018, freightliner-cascadia-2019, freightliner-cascadia-2020, freightliner-cascadia-2021, radiator 1 year warranty, radiator pt, spinimages=16
Unquote

I need to remove everything BUT:

freightliner-cascadia-2017, freightliner-cascadia-2018, freightliner-cascadia-2019, freightliner-cascadia-2020, freightliner-cascadia-2021

Basically, if the sub-string does not end on a year, I want to remove it. Comma is a delimiter between substrings.

In the attached, I was able to split the data in Power Query so that each item is on a row by itself. I was then able to remove the suggested items. You can see this new table. I then tried to repivot the data in Power Pivot so that it was in the same format as you had as your source data. Power Pivot could not allow this as it indicated that each cell would exceed the character limit. Perhaps you can work with what I have supplied.

Making the data into a table called Table1, then this should work:

Please Login or Register  to view this content.

See attached.

Alternate Vba Solution...

Please Login or Register  to view this content.

but I cannot use macros.

pity...provides correct results...

Small change required:

Please Login or Register  to view this content.