Replace Text - Starts with and Ends with

[jmoeller]

I am new to Power Query/M and I am stuck.  I know what I need to do, just not how.

Source Text:

http://crl.security.com/1.crl
Creation Date: 2/15/2018 11:45:00 AM
Next Publish Date: 5/15/2018 12:55:00 PM
Expiration Date: 6/15/2018 1:05:00 PM

  I want to replace all text starting with "Creation Date:" through "Expiration Date:" with a comma so that my results look like...

Desired Results:

http://crl.security.com/1.crl,6/15/2018 1:05:00 PM

Note that the actual dates between the two will vary.

Any advice to get me started would be appreciate.

[ImkeF · Accepted solution]

This formula shoud do:

Text.Clean(Text.BeforeDelimiter(YourText, "Creation Date")) & ", " & Text.AfterDelimiter(YourText, "Expiration Date:")