Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Replace blocks of text in librecalc using regexp

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, 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.

Paragraph 1

Paragraph 2

Paragraph 3

%the following are all repeated after 2 paragraph spaces

Paragraph 1

Paragraph 2

Paragraph 3

Replace blocks of text in librecalc using regexp

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, 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.

Paragraph 1

Paragraph 2

Paragraph 3

%the following are all repeated after 2 paragraph spaces

Paragraph 1

Paragraph 2

Paragraph 3

Replace blocks of text in librecalc using regexp

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, 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.

Paragraph 1

Paragraph 2

Paragraph 3 Paragraph 2

Paragraph 3 %the following are all repeated after 2 paragraph spaces

Paragraph 11 %these are all repeated after the 2 paragraph spaces)

Paragraph 2

Paragraph 3

Replace blocks of text in librecalc using regexp

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, 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.

Paragraph 1

Paragraph 2

Paragraph 3

Paragraph 1 %these are all repeated after the 2 paragraph spaces)spaces

Paragraph 2

Paragraph 3

Replace blocks of text in librecalc using regexp

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, 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.eg. %this appears in a single cell

Paragraph 1

Paragraph 2

Paragraph 3

Paragraph 1 %these are all repeated after the 2 paragraph spaces

Paragraph 2

Paragraph 3

%I'd like the output to just show Para 1, Para 2 and Para 3 without the duplicate

Replace blocks of text in librecalc using regexp

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 spaces

Paragraph 2

Paragraph 3

%I'd like the output to just show Para 1, Para 2 and Para 3 without the duplicateC:\fakepath\Sample file.ods

Replace blocks of text in librecalc using regexp

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 spaces

Paragraph 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: C:\fakepath\Sample file.ods

Replace blocks of text in librecalc using regexp

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 spaces

Paragraph 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: C:\fakepath\Sample file.odshere