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.
[Solved] Find and insert rather that find and replace
-
The Half Mad Poet
- Posts: 2
- Joined: Thu Jul 18, 2024 1:21 am
[Solved] Find and insert rather that find and replace
Last edited by Hagar Delest on Thu Jul 18, 2024 8:00 am, edited 1 time in total.
Reason: tagged solved.
Reason: tagged solved.
OpenOffice 4.1.14 on Windows 10
Re: Find and insert rather that find and replace.
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.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: Find and insert rather that find and replace.
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.
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.
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