https://bugs.documentfoundation.org/show_bug.cgi?id=153738
Bug ID: 153738
Summary: Large text file - search and replace extremely slow
Product: LibreOffice
Version: 7.3.2.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Writer
Assignee: [email protected]
Reporter: [email protected]
Created attachment 185474
--> https://bugs.documentfoundation.org/attachment.cgi?id=185474&action=edit
Text data from a dos database of image information in 8 fields for each record
I am trying to import data (over 30,000 records) from an old dos system. I have
exported the data into a text file from within the dos programme, with a
paragraph separator - the options are limited and none of the others will work.
So the end-of-field and end-of-record separators are both $ (or\n). The file
opens OK in Notepad.
I need to import into Calc, but I have to search and replace in Writer to
organise the data into an importable form. Each record begins with '10' which
doesn't appear after a line break anywhere else, so I search for ^10 and
replace with @@10, to identify all the end-of-records. Then I want to replace
the remaining end of paragraphs with tabs, so I search for $ and replace with
\t. This was taking an immense time - hours - so I force-quit and instead
searched for $ and replaced with %% to enable me to later replace %% with \t. I
was of course using regular expressions.
So now I want to search for @@ and replace with \n. But again this is taking
hours.
I am attaching a file which is only a quarter of the data.
I have also tried using LO 7.5.0.3 on a different machine.
--
You are receiving this mail because:
You are the assignee for the bug.
