--- title: "About Regular Expression Replacement" slug: "string-replacement" updated: 2024-08-15T09:41:40Z published: 2024-08-15T09:41:40Z canonical: "documents.trocco.io/string-replacement" --- > ## Documentation Index > Fetch the complete documentation index at: https://documents.trocco.io/llms.txt > Use this file to discover all available pages before exploring further. # About Regular Expression Replacement ## summary This function replaces part of a string in a column with another string during transfer. ## How to use Data Settings in **STEP.2 Preview and Advanced Settings** in ETL Configuration. After **Data** Setting, **save and preview the** data, and you will see the applied column data in the preview window. ## (technical) specification - Multiple replacement settings can be applied to a single column. - Please refer to the [official documentation](https://github.com/cesare/embulk-filter-gsub). - [Java's regular expression notation](https://docs.oracle.com/javase/jp/8/docs/api/java/util/regex/Pattern.html) can be used for regular expressions. ## reference [https://github.com/cesare/embulk-filter-gsub](https://github.com/cesare/embulk-filter-gsub)