How to replace some text in the field during import

In this tutorial we will find out how to find and replace needed text in the field during import.

For example, we need to find in the field "Product name" text "Green" and replace it to "Red".

Find & Replace formula has such structure: [your_field_name] => TEXT_FOR_SEARCH => TEXT_FOR_REPLACE

So in our example formula will be so: