Frequently asked questions - Calc

    From The Document Foundation Wiki
    < Faq‎ | Calc


    How to search for several terms at once

    Context

    You want to search for more than one text string (example: 12, 25) at once in a selected range using the "Find & Replace..." dialog in Edit ▸ Find & Replace... menu.

    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 of the "paragraph" respectively:

    copie d'écran recherche
    La recherche est fructueuse