Find and Replace
The Find and Replace feature allows you to quickly search your dataset for specific text and replace any or all occurrences. You can search both row names and cell values across your entire dataset.
Opening Find and Replace
To begin, click the Cells button in the Dataset toolbar, then select Find and Replace from the menu.
Search Options
With the Find and Replace dialog open, enter the text you wish to search for in the Find field. Optionally, enter replacement text in the Replace with field.
Search Settings
You can customize how the search works using two checkboxes:
| Option | Description | Example |
|---|---|---|
| Match whole words only | When checked, only matches complete words. When unchecked, matches text anywhere including parts of words. | Unchecked: Your opponent may not play a card for the chosen Company on their next turn if able. Checked: Your opponent may not play a card for the chosen Company on their next turn if able. |
| Match case | When checked (default), only matches text with the same uppercase/lowercase characters. When unchecked, ignores case differences. | Unchecked: The card you play does not modify the result. Checked: The card you play does not modify the result. |
By default, Match case is enabled. This means searches are case-sensitive unless you uncheck this option. Whole word matching is disabled by default.
Find All
Click the Find All button to search the entire dataset. The dialog will show:
- Total number of matches found
- A list of all matching locations (up to the first 10 visible)
- For each match, whether it's in a row name or a specific cell
- A preview of the matching text
You can click the arrow button next to any match in the list to navigate directly to that location in the dataset. The table will scroll to the match and briefly highlight it.
When matches are found, you'll see a counter like "1 of 5" showing which match is currently selected.
Replace
The Replace button replaces the current match (the one highlighted in the match list) with the text in the "Replace with" field. After replacing, the match is removed from the list and the next match becomes current.
This allows you to replace matches one at a time, reviewing each occurrence before deciding to replace it. To skip a match without replacing it, simply click on a different match in the list.
- Click Find All to see all matches
- Review the first match (automatically selected)
- Click Replace to replace it, or click a different match to skip
- Repeat until all desired replacements are made
Replace All
Click the Replace All button to instantly replace every occurrence of the search text throughout the entire dataset. This happens immediately with no confirmation step.
If you leave the "Replace with" field empty, Replace All will delete all matching text from the dataset.
After the replacement completes, you'll see a success message showing how many occurrences were replaced, and the search will automatically run again to show any remaining matches.
Replace All happens instantly with no undo confirmation. Make sure your search is set up correctly before using this feature. Consider using the single Replace button first to verify the replacements are what you expect.
What Gets Searched
Find and Replace searches in two locations:
- Row Names: The name field of each row
- Cell Values: The content of all cells in your dataset
The match list shows you which type of location each match is in, making it easy to see where your text appears.
Tips and Best Practices
Test Your Search First
Always use Find All before replacing to see what will be affected. Review the match list to ensure you're finding what you expect.
Use Match Case for Precision
When you need to preserve capitalization differences (like "The" vs "the"), keep Match case checked. This prevents unintended replacements.
Whole Words for Common Terms
When replacing common words like "the" or "is", enable Match whole words only to avoid changing them when they appear inside other words.
Empty Replacement = Deletion
If you want to remove text entirely, leave the "Replace with" field empty. This effectively deletes all matching text.
Navigate Before Replacing
Click the arrow next to any match to jump to that location in your dataset. This lets you see the context before deciding to replace.
Common Use Cases
Search for "recieve" and replace with "receive" across all cells to fix a common spelling error.
Change all instances of "Hit Points" to "Health Points" when renaming a game mechanic.
Search for "TODO" with an empty replacement to delete all placeholder markers.
Search for "damage" and use the single Replace button to replace only specific instances while skipping others.
Summary
Find and Replace is a powerful tool for making bulk text changes across your dataset. Use Find All to locate text, Replace to replace one match at a time, or Replace All to change everything at once. The match list and navigation features help you review and control exactly what gets replaced.