.. _auto_dataset_replace_column_names:

*SEARCH AND REPLACE COLUMN NAMES*
=================================

Performs a search-and-replace operation on all column names in a dataset, substituting every occurrence of a given search string with a replacement string. Use this worker to rename columns in bulk — for example, stripping prefixes, fixing typos, or standardising naming conventions before downstream processing.

When to use
-----------

Classification: **process**.

Tagged: ``bulk_rename``, ``column_names``, ``column_rename``, ``dataset_transform``, ``search_replace``.

Inputs
------

.. list-table::
   :header-rows: 1
   :widths: 20 20 20 20 20 20

   * - Label
     - ID
     - Type
     - Default
     - Required
     - Description
   * - Dataset
     - dataset
     - dataset
     - —
     - 
     - Input dataset whose column names will be modified; pass any tabular dataset object whose headers need renaming.
   * - Search
     - search
     - scalar
     - —
     - 
     - The substring to search for within each column name (case-sensitive, plain text); leave empty to match nothing.
   * - Replace
     - replace
     - scalar
     - —
     - 
     - The replacement substring that will overwrite every match found by the search string; leave empty to effectively delete the matched substring from column names.

Outputs
-------

.. list-table::
   :header-rows: 1
   :widths: 20 20 20 20

   * - Label
     - ID
     - Type
     - Description
   * - Replaced Dataset
     - dataset_replace_column_names
     - dataset
     - A copy of the input dataset with all column names updated — every occurrence of the search string replaced by the replacement string; data values are unchanged.

Disciplines
-----------

- data.dataset.transform

Runnable example
----------------

A runnable example is registered for this worker. Open the example workflow on the d3VIEW canvas: `/api/workflow/example?id=dataset_replace_column_names <https://www.d3view.com/api/workflow/example?id=dataset_replace_column_names>`_

.. raw:: html

   <hr style="margin-top:2em">
   <p style="font-size:11px;color:#888">
   Auto-generated from <code>transformation</code> schema. Worker id: <code>dataset_replace_column_names</code>. Schema hash: <code>ea29cfd7ae82</code>. Hand-curated docs in <code>workerexamples/</code> override this page when present.
   </p>