Delete Rows Between Same String Value

Howdy,

I'm trying to delete rows between two same string values and delete empty lines more than 1. But I couldn't find a proper tool to perform that.

I tried Record ID tool but the position of this string value changes for every file.

Below is the sample text

Regex

Preparation

Accepted answers

Blake

Let me know if the attached workflow works for you.

thordust.yxmd

All comments

Blake

Hi @Thordust16, I'd like to help you with your solution but I don't quite understand your question. Can you mock up what you'd like your data to look like after you run it through Alteryx?

Thordust16

Hi Blake

Thanks for replying.

Below is the desired output.

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703