[Solved] Find and replace multiple values at once in OpenOffice

[pe7er]

I know there are online tools, but this is a good software, and I would like to do this directly while working.

Thanks in advance for any advice.

[Hagar Delest]

Do you mean replace multiple instances of a single one string? In this case standard Find & Replace feature is the way to go.
If you want to replace several strings, then you may use a macro and either hard code the strings or create a dialog to provide them.

[pe7er]

I mean something like this:

image F.jpg (36.75 KiB) Viewed 4778 times

[floris v]

If the strings that you want to replace follow some pattern, you may try something with regular expressions, aka wildcards. If they are all completely different, you will probably need a macro to do the replace commands batch wise.

[RoryOF]

Find and Replace is so fast you might be better advised to do individual Find and Replace cycles for each unique instance than to be looking for and debugging some automated method of doing the task.

Alternately, download and install AltSearch extension and use its batch mode.

[JeJe]

With regular expressions ticked you can do a search for multiple items by separating them with "|" eg "fish|mammals" will find both.

But to do a replace like you want you'll either need a macro, or you could download the AltSeach extension and look at batch operations using it as RoryOF says.

https://extensions.openoffice.org/en/pr ... -altsearch

[Bill]

I know there are online tools, but this is a good software, and I would like to do this directly while working.

Thanks in advance for any advice.

OpenOffice can't do this. The online tool has multiple "find" and "replace" boxes. OpenOffice does not.

Find and Replace - Multiple Text Online

[JeJe]

Correction: AltSearch does this without needing a batch file. From the help:

text1||text2||text3||… - multiple search and replace operations in one step:
Add the sign || to the end of the search and replace expressions to delimit the partial searches and replacements.
Search for: text1||text2||text3
Replace: neco1||neco2||neco3
This will search for text1 and will replace it with neco1, then continue the search for text2, replace it by neco2, etc.