Editing table data: The Edit menu



    Cut / copy text to clipboard


The Cut command, (hot-key Ctrl-x), will function the same as in Excel. Data from the highlighted cells will be copied to the clipboard and deleted from the original cells.
This operation cannot be performed on the "Selected" or "File Path" columns.

The Copy command, (hot-key Ctrl-c), also copies the highlighted cell data to the clipboard but does not delete the original data.

The data in the "Selected" or "File Path" columns can be copied to the clipboard but the "Selected" column, when pasted to a new column or another application, will display as the words "true" or "false".


    Paste clipboard data into table cells


There are two paste commands on the Edit menu.

The first, "Paste contents of clipboard starting at highlighted cell."  (hot key Ctrl v ) functions the same as the paste command in Excel. The contents of the clipboard, presumably the contents of a group of cells, will be pasted into the table beginning at the highlighted cell. Only the beginning cell needs to be highlighted.

If the contents of the clipboard consist of the data from multiple rows and / or columns it will be posted into the same number of row and columns overwriting the current contents. If there are not enough cells to hold the pasted data any excess is simply lost. In other words if you try to paste ten rows of data into the last five rows of a table the last five rows in the clipboard will be discarded.

NOTE: You can only paste into
user editable columns. You cannot paste into predefined columns or into columns containing data read from a SEGY header.

The other paste command, "Paste single value from clipboard into all highlighted cells", ( hot key Shift V ) will paste the same clipboard contents, presumably the data from one cell or a small text string, into all highlighted cells. As in the previous paste command you can only paste into user editable columns. This option could be used to paste a project name into multiple rows of a table for instance.


    Erase cell contents


This function will clear the current contents of the highlighted cells. Only the contents of user editable columns can be erased. At present there is no un-erase function so use with care.


    Edit text in cells


Use this function to edit the contents of all the highlighted cells. The columns "Selected" and "File Path" cannot be edited.

Note that this function only alters the contents of the cell. It does not change the values in the SEGY file the cell represents. This function is primarily used to edit
user editable columns.

Note that searches are case sensitive so "ABC" does not match "Abc". All text must be enclosed in the double quotes in the text boxes.

There are seven editing options.

  1. Replace each occurance:  For example if the first text box contained "STK" and the second contained "MIG" the string "Line-10-STK-Filtered" would be changed to "Line-10-MIG-Filtered"

  2. Terminate string at first occurrence of:  For example if the string in the text box was "filtered stack" and the string to be edited was "Project Heckkandgone filtered stack" the edited string would read "Project Heckandgone".

  3. Start string at first occurrence of:  for example if the text box contains "Filtered stack" and the string to be edited was Filtered stack Line 10" the edited string would read "Line 10".

  4. Append this to end of string:  If the string in the text box was "-Proprietary" and the string to be edited was "Line 10" the resulting string would read "Line 10-Proprietary"

  5. Insert this at beginning of string:  The same as the above except the string in the text box is inserted at the beginning of the string to be edited.

  6. Set entire string to upper case:  Changes "abcdefg" to "ABCDEFG".

  7. Set entire string to lower case:  Changes "WXYZ" to "wxyz".

This dialog wil remain up after the "Edit" button is clicked.

The "Undo" button will reverse the previous edit but only if the dialog has not been closed and the edit cells are still highlighted.


    Rename columns


Use this function to rename the highlighted column.

The "Selected", "File Path", and predefined columns cannot be renamed.

Blanks in column names are OK. Special characters such as "@,#,%,*,+)" are not.


    Remove columns or rows


Use these functions to delete the highlighted column(s) or row(s) from the table. The deleted columns are not removed from the underlying configuration file.


    Copy row contents to other table


This function copies the selected rows from the current table to a new or existing table All the columns of the selected rows are copied exactly.

If copying to a new table you must supply a table name. Any alpha-numeric string can be used so long as the string doesn't duplicate an existing table name.

If copying to an existing table you must ensure the both tables have the same column configuration.


    Rename current table


Use this function to rename the selected table.


    Delete current table


Use this function to delete the current table. No SEGY data is lost, no files are deleted.


    Rename selected SEGY files


This function will rename one or more SEGY files.

The table at the top of the dialog shows the selected SEGY files with the original names and the same files with the altered names. Not all files in the list need to be renamed the same way.

Note that the files are not actually renamed while this dialog is visible, only after the "Rename" button is clicked. In case of mistakes the highlighted files can be reset to the original names by clicking the "Reset" button.

The "Search" button will search the first column of the table for string patterns and highlight the matching rows. The "Remove" button wil remove files from the table but not actually delete them.

Right clicking the mouse will display the EBCDIC header for the first highlighted row in the table.

Files can be renamed one at a time by typing directly into the second column of the table. Multiple files can be renamed by using one of the editing functions.

Prepend:  Will add the string from the text box to the beginning of the file name. So if "ABC-" was entered into the text box the file "XYZ-1.sgy" would be rename to "ABC-XYZ-1.sgy".

Append:  The same as above except the string from the text box is added to the end of the file name.

Replace:  If the string in the first text box is found in the file name of any selected file it will be replaced with the string from the second box. The strings and file names are case sensitive.

Insert:  The string from the first text box is inserted into the file name before or after the text in the second text box only if it exists in the selected file name.


    Change SeisX / SeisWare line names


This function works in a similar way to the above Rename File function except that it changes the SeisX / SeisWare line name written in bytes 301-320 of the binary header.

The file name, original line name and altered line name are shown in the table at the top of the dialog. The buttons below the table function the same as in the Rename Files dialog.

The same editing options are available plus an option to use the file name, up to the first dot, as the new line name.
when the "Change" button is clicked, and not before, the new line names are written in bytes 301-320 of the binary header.


    Copy or link SEGY files


This function will copy the SEGYs in the selected rows to a new location on the network.

Use the "Browse" to select a directory to copy the files to.

If you are on a platform that supports links such as Linux or Unix you have three more options.

Copy the files to the target directory. If a copied file is a link the link will point to the same target from the new directory.

If the file to be copied is a link copy the target file to the new directory rather than the link.

Don't copy the selected file, just create a symbolic link in the new directory.

Note that this is a copy function, not a move. The original files or links will remain where they were.


    Delete SEGY files


This function will physically delete the SEGYs in all selected rows.

A warning will appear to remind you that there is no "Undelete" so this operation is final.

The rows containing the deleted files are removed from the table.


    Lock or unlock highlighted cells


These functions will lock or unlock the highlighted cells.

By locking a cell no changes can be made to the cell contents. Useful for editable columns you have pasted text into that you don't want to accidentally erase.