I’m new with regexp. I am working with a buggy program that exports text to spreadsheet form. The bug creates duplicate blocks of text in a cell, the duplicate follows a double paragraph space. Example is shown below. Can regexp and find/replace get ride of the duplicate text? Can anyone assist with the regexp needed?
eg. %this appears in a single cell
Paragraph 1
Paragraph 2
Paragraph 3
Paragraph 1 %these are all repeated after the 2 paragraph spacesParagraph 2
Paragraph 3
%I’d like the output to just show Para 1, Para 2 and Para 3 without the duplicate
Sample data file here