Frequently asked questions - Calc

From The Document Foundation Wiki
< Faq‎ | Calc
Jump to: navigation, search

How to search for several terms at once


You want to search for more than one text string (example :12, 25) at once in a selected range using the "Search and replace" dialog.

The | character is used in regular expressions to search on what is entered before or after the sign.

But you can't just search for 12|25 because the text (or numbers) could equally occur in combinations like 123, 255, 312, etc.

copie d'écran recherche
La recherche est trop large

Solution Add the expressions ^ and $ to indicate that the search term should only occur at the start and the end respectively of the "paragraph" :

copie d'écran recherche
La recherche est fructueuse