Replace action in Apple Numbers package

The Replace action in the Apple Numbers package enables you to find and replace all instances of the specified text within the active or specified table on the active sheet.

Settings

  • Use one of the following options to provide session name:
    • Session name: Enter the name of the session used to open the spreadsheet with the Open action.
    • Variable: Enter the session variable that you added in the Open action.
  • Enter the exact text you want to search for in the Find text field. For example, employee ID.
  • Use the following options to match the search criteria:
    • Match Case: Only matches with the same capitalization as find text (Case-sensitive matching).
    • Match whole words: Limits matches to whole-word instances (avoid partials).
  • In the Replace text field, type the value to replace the found text with.
  • Choose where to perform the replace:
    • Active table: Uses the currently active or selected table in the sheet.
    • Specific table : Type the exact table name (For example, Table 11: SalesData).
  • Specify the scope of the search in the Table range field.
    • From: Select from the following list to begin your search:
      • Beginning
      • End
      • Active cell
      • Specific cell
    • Till: Select from the following list to define the extent of your search in the specified table.
      • Beginning
      • End
      • Active cell
      • Specific cell
  • Choose from the following search options :
    • By Rows: Scans left to right across the first row, then the next row.
    • By Columns: Scans top to bottom down the first column, then the next column.

When you specify the attributes mentioned above, during the execution of the action, it will search the identified table for all occurrences of the Find text string and replace the found text with the Replace text string. The Match case criteria will ensure that the search is case-sensitive, meaning it will only match if all letters in the string are identical in case (for example, Roger will not match roger or ROGER). The Match whole words criterion will only match complete words; if not specified, sub strings within words can be matched instead. The table range can be defined starting from either the beginning or the end of the table, or it can be specified using cell addresses. You can use any combination of the beginning, end, and cell addresses to set the range.