How to match this fields?

-- HikaShop version -- : 3.3.2
-- Joomla version -- : 3.8.6
-- PHP version -- : 5.6

See file img attached

CSV FILE
Column1:
1: "product"
2: "model"
3: "model"
4: "product"
5: "model"

Column2:
1: empty field
2: 24121
3: 24122
4: empty field
4: 24130

CSV HIKASHOP
Column: Product_Parent_ID
1: 0
2: 0
3: 94133
4: 94133
5: 94133

Column: Product_Type
1: Main
2: Main
3: Variant
4: Variant
5: Variant

The MODEL_ID (CSV) Column can matches the PARENT_ID (HIKASHOP) Column. I guess the empty field will be read from Hikashop like a 0.

Regarding the RECORD_TYPE (CSV) column I don't know how to match with the PRODUCT_TYPE (Hikashop) column.
I should replace all words "PRODUCT" and "MODEL" in the specific column, with MAIN and VARIANT but is there a formula in excel to do that?
Any other solution? Consider, my aim is to avoid making changes to the CSV or to do minor changes.

Hi,

You can do that in Excel yes:
support.office.com/en-us/article/find-or...08-b90f-fdb42f892e90
Alternatively, you could easily do it in notepad++ with the search/replace function
docs.notepad-plus-plus.org/index.php/Searching_And_Replacing