User Tools

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision		Previous revision
geoscene3d:add_geophysics:remove_cols_geophysics [2026/08/10 09:45] – created devgeoscene3d:add_geophysics:remove_cols_geophysics [2026/08/10 11:46] (current) – [Non-numbered Columns] dev
Line 1: Line 1:
 +
 ====== Remove Columns from XYZ Files ====== ====== Remove Columns from XYZ Files ======
  
 +The **Remove Columns from XYZ Files** function is available in the **Toolbox** in GeoScene3D.
 +
 +To use the function, first select one or more XYZ files in the Toolbox. Then open the **Operations** menu and select **Remove Columns from XYZ Files**.
 +
 +Multiple XYZ files can be selected and processed in the same operation.
 +
 +It creates a new XYZ file containing only the required columns.
 +
 +It is intended for XYZ files that contain groups of numbered columns, for example:
 +
 +  * RHO_1, RHO_2, RHO_3, ...
 +  * DEP_TOP_1, DEP_TOP_2, ...
 +  * DEP_BOT_1, DEP_BOT_2, ...
 +
 +You specify which groups of numbered columns should be kept by adding their prefixes to the beginning of the file header.
 +
 +===== Preparing the XYZ File =====
 +
 +At the beginning of the XYZ file, add one line for each numbered column prefix that you want to keep.
 +
 +End the list with:
 +
 +<code>
 +/COLS END
 +</code>
 +
 +For example:
 +
 +<code>
 +/RHO_
 +/DEP_TOP_
 +/COLS END
 +</code>
 +
 +With this configuration, the exported file will keep columns such as:
 +
 +<code>
 +    RHO_1    RHO_2    RHO_3    ...    DEP_TOP_1    DEP_TOP_2    DEP_TOP_3    ...
 +</code>
 +
 +Any other numbered column groups will be removed.
 +
 +===== Non-numbered Columns =====
 +
 +Columns that do not have a numbered suffix are kept automatically.
 +
 +For example:
 +
 +<code>
 +X   Y   Z   LINE
 +</code>
 +
 +These columns do not need to be listed in the /COLS section.
 +
 +==== Example =====
 +
 +Assume the original XYZ file contains the following columns:
 +
 +<code>
 +X    Y    RHO_1    RHO_2    ...    DEP_TOP_1    DEP_TOP_2    ...    COND_1    COND_2    ...
 +</code>
 +
 +and the beginning of the file contains:
 +
 +<code>
 +/RHO_
 +/DEP_TOP_
 +/COLS END
 +</code>
 +
 +The exported file will contain:
 +
 +<code>
 +X    Y    RHO_1    RHO_2    ...    DEP_TOP_1    DEP_TOP_2    ...
 +</code>
 +
 +The following numbered column group will be removed:
 +
 +<code>
 +COND_1    COND_2    ...
 +</code>
 +
 +===== Output File =====
 +
 +The original file is not modified.
 +
 +A new file is created in the same location as the source file. A timestamp is added to the filename.
 +
 +Example:
 +
 +<code>
 +SurveyData_20260810_113500.xyz
 +</code>
 +
 +The filename format is:
 +
 +<code>
 +OriginalFile_YYYYMMDD_HHMMSS.xyz
 +</code>
 +
 +The output columns are automatically formatted to accommodate the longest value found in each retained column.
 +
 +===== Missing /COLS END =====
 +
 +The ''/COLS END'' marker is required.
 +
 +If the marker is not found, the operation is cancelled and a message explains how to configure the file header.
 +
 +A valid configuration could be:
 +
 +<code>
 +/RHO_
 +/DEP_TOP_
 +/COLS END
 +</code>
 +
 +===== Summary =====
 +
 +To remove unwanted numbered columns from one or more XYZ files:
 +
 +  - Open the **Toolbox**.
 +  - Select one or more XYZ files.
 +  - Open the **Operations** menu.
 +  - Select **Remove Columns from XYZ Files**.
 +  - Make sure the prefixes of the numbered column groups you want to keep are listed at the beginning of each file.
 +  - Add ''/COLS END'' after the final prefix.
 +  - Run the operation.
 +  - A new timestamped XYZ file is created for each processed file.
 +
 +Non-numbered columns are retained automatically.

This website uses cookies. By using the website, you agree with storing cookies on your computer. Also, you acknowledge that you have read and understand our Privacy Policy. If you do not agree, please leave the website.

More information