New Features Added to RockWorks17 Datasheet Find & Replace

(228-241) New Features (03/30/16/JPR): The Datasheet | Search | Find & Replace program has been significantly enhanced:


The Find & Replace utility may be used to find specified text and numeric values within a designated column. Based on the results, the data may be simply highlighted (i.e. a simple “Find” operation), replaced, or the associated data row(s) can be enabled or disabled.  The options within the Find & Replace menu are described as follows:

  • Data Column: The column that is to be searched.
  • (228) Where to Start?
  • First Row: The search will start at the first row in the datasheet and progress down through the datasheet.
    • Current Row: The search will start at the row that contains the cursor and progress down through the datasheet.
  • (229) Type of Search?
    • (230) Text: Used to search for text strings (e.g. lease name).
      • Target: The text “string” to be searched for.
      • Case Sensitive: If unchecked, the case doesn’t matter (e.g. “Acme Lease” is considered the same as “ACME LEASE”).
      • (231) Target in Cell: Cell content can be a subset of cell target. Example: Enabling only monitor wells when all monitor well names begin with “MW” and all production wells begin within “PW”.
      • (232) Cell in Target: Cell content can be a subset of the target. Example: If searching for “Oil Well”, a cell labeled “Well” will be considered a match.
    • (233) Numeric:
      • (234) Exact: The target and the cell must have exactly the same values. Trailing zeroes are ignored.
      • (235) Range: All values between a specified mininum and maximum will be considered a match.
        • Minimum: Values equal to or greater than this value and less than or equal to the specified Maximum will be considered a match.
        • Maximum: Values less than or equal to this value and greather than or equal to the specified Minimum will be considered a match.
      • (236) Statistical: This option will look at all of the data within the specified column and compute the mean and standard deviation. The selected filter will then be used to locate the cells that fall within the designated category.
        • Background: Filters values are between the mean minus one standard deviation and the mean plus one standard deviation.

(M-1SD) > X < (M+1SD)

  •  Slightly Positively Anomalous: Filters values that are between the mean plus one standard deviation and the mean plus two standard deviations.

(M+1SD) > X < (M+2SD)

  •  Moderately Positively Anomalous: Filters values that are between the mean plus one standard deviation and the mean plus two standard deviations.

(M+2SD) > X < (M+3SD)

  • Strongly Positively Anomalous: Filters values that are between the mean plus one standard deviation and the mean plus two standard deviations.

(M+3SD) > X < (M+4SD)

  • Extremely Positively Anomalous: Filters values that are between the mean plus one standard deviation and the mean plus two standard deviations.

X > (M+4SD)

  •  Slightly Negatively Anomalous: Filters values that are between the mean plus one standard deviation and the mean plus two standard deviations.

(M-2SD) > X < (M-1SD)

  •  Moderately Negatively Anomalous: Filters values that are between the mean plus one standard deviation and the mean plus two standard deviations.

(M-3SD) > X < (M-2SD)

  •  Strongly Negatively Anomalous: Filters values that are between the mean plus one standard deviation and the mean plus two standard deviations.

(M-4SD) > X < (M-3SD)

  •  Extremely Negatively Anomalous: Filters values that are between the mean plus one standard deviation and the mean plus two standard deviations.

X < (M-4SD)

  • (237) What to Do?
    • (238) Highlight Cell: The first cell that meets the search criteria will be highlighted and the process will terminate (without showing a summary dialog). This is the same as a simple “Find” operation (i.e. no replacement).
    • (239) Enable/Disable: The Enable/Disable options are best used in conjunction with the Edit | Enable All and Edit | Disable All options. Example: Let’s say that you’re working with a geochemical dataset and you only want to plot points that have calcium level greater than 50%.
      •  Enable: The checkbox within the “Use” column will be checked for all rows in which the target is found.
      •  Disable: The checkbox within the “Use” column will be un-checked for all rows in which the target is found.
    • (240) Replace:
      •  Replacement: The text string that will replace the cell(s) that meet the search criteria. Note: This can be any text, thereby allowing you to replace numeric searches with text strings (e.g. values < 1.0 replaced by “Below Detection Limit”).
      • (241) Confirm Replacements: If checked, the user will be prompted before each replacment. The confirmation dialog provides options for accepting the replacement, denying the replacement (and proceeding with the search), canceling the operation, and making all subsequent changes without additional confirmation.


  •  Show Summary: Displays a dialog after completion that shows the number of matches that were located and/or the number of changes that were made.


Note: The searching ignores the status of the Use column. In other words, all rows are scanned.

Comments are closed.