[Solved] Find and insert rather that find and replace

Discuss the word processor
Locked
The Half Mad Poet
Posts: 2
Joined: Thu Jul 18, 2024 1:21 am

[Solved] Find and insert rather that find and replace

Post by The Half Mad Poet »

I've got a series of data that looks like this:

aoeu8eui6dbd9qjohui5bedu4

And I need it to look like this:

aoeu8
eui6
dbd9
qjohui5
bedu4

But it's almost 11,000 lines long.

I'm trying to find a way to search for every instance of a number followed by a letter and place a paragraph mark between them. With the Find & Replace dialogue and the Alt Find & Replace dialogue I haven't found a way to do this because once it finds the combo, I can only replace them, not keep them and insert the paragraph mark between them.
Last edited by Hagar Delest on Thu Jul 18, 2024 8:00 am, edited 1 time in total.
Reason: tagged solved.
OpenOffice 4.1.14 on Windows 10
FJCC
Moderator
Posts: 9625
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Find and insert rather that find and replace.

Post by FJCC »

Using your example text, I searched for \w\d and I replaced it with &\n. With regular expressions turned on on More Options, I got your desired result when I click Replace All.
 Edit: It also works to search for (\d)(\w) and replace with $1\n$2 
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
User avatar
robleyd
Moderator
Posts: 5509
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Find and insert rather that find and replace.

Post by robleyd »

Alternatively, using Writer's native Find/Replace with Regular expressions enabled, search
([:digit:])([:alpha:])
and replace
$1\n$2
.
Slackware 15 (current) 64 bit
Apache OpenOffice 4.1.16
LibreOffice 26.2.3.2; SlackBuild for 26.2.3 by Eric Hameleers
---------------
I hate this damn computer, I wish that I could sell it.
It won't do what I want it to, Only what I tell it.
The Half Mad Poet
Posts: 2
Joined: Thu Jul 18, 2024 1:21 am

Re: Find and insert rather that find and replace.

Post by The Half Mad Poet »

Thank you both for the responses, I was able to get it to work perfectly with the solution from robleyd. FJCC's solution also worked but there were some places with double and triple digits that it didn't work quite as well for this use. But both were great solutions. Thanks!
OpenOffice 4.1.14 on Windows 10
Locked