Overview
When validating, processing, and publishing tabular data in VRIFY Prepare, you can edit data directly in the workspace rather than modifying source files.
This option is available for Drilling and Surface Geochemistry data types, but not Block Models.
After saving your field mapping and running validation, you can review issues in the Validate step, correct affected rows inline, and select Save and Re-validate. Prepare saves your changes and re-validates automatically so you can confirm them.
Step by Step Instructions
Tabular editing is available in the Validate step for Drilling and Surface Geochemistry data types only.
Complete the Field Mapper step, then click Save.
Click the Validate step, then click Validate.
When validation is complete, review the list of issues in the Validate step in the right sidebar.
Click an issue to filter and highlight the affected rows in the workspace.
Click into a cell to edit it directly.
Click Save and Re-validate. Prepare saves your edits as a new version and re-validates automatically.
To make bulk changes, select Find and Replace and apply your edits. Replacements stay staged until you select Save and Re-validate.
You can select specific rows or columns using the filters:
When validation finishes, review the results to confirm your changes.
Find and Replace Options
Select Find and replace at the top of the table to open the controls. Use them to find values in the table and replace them with a new value.
Find: Enter the value to look for.
Match: Choose Contains, Exact match, Empty cells, or Non-numeric values. Non-numeric values is available only when the selected column holds numbers.
Search: Search All columns or a single column.
Match case: Select to match capital and lowercase letters exactly.
Only rows in the current filter: Appears when you have filtered the table by an issue. Select it to apply the find and replace to those rows only.
Filter rows: Appears when there are matches. Select it to show only the rows that match.
Previous match and Next match: Use the arrows to move through the matches. The match count shows how many were found, for example "2 of 14 found".
Replace entire cell with...: Enter the new value. It replaces the whole cell, not only the text that matched.
Replace changes the current match. Replace all changes every match.
Replacements are staged, not saved. Open the Unsaved changes list to review them, select Remove to drop a single change, or select Discard all. Select Save and Re-validate to apply them.
Ignore Rows
Use Ignore to remove rows from the file instead of correcting them.
Select the checkbox beside each row you want to remove. Use the checkbox in the header to select all visible rows, or select Clear selection to start over.
Select Ignore. The button shows how many rows are selected.
In the confirmation, select I understand and wish to continue, then select Ignore rows.
Prepare removes the rows and starts re-validation automatically.
Important: Ignoring rows deletes them from this file. Prepare warns that the only way to revert this change is to re-upload your file. Ignore is unavailable while you have unsaved changes, so save or discard them first.
Additional Notes
Find and Replace is useful when the same value appears across many rows — for example, correcting a unit label or standardizing a column entry applied to the entire dataset.
Editing is paused while validation is out of date. After you save, a banner reads "Edits are saved, but validation indicators are out of date. Editing is paused until you re-validate." Wait for validation to finish before making more edits. If validation does not start on its own, select Re-validate.
Learn More
Still Have Questions?
Reach out to your dedicated VRIFY contact or email support@vrify.com for more information.