W
W
WebforSelf2021-10-05 13:06:45
excel
WebforSelf, 2021-10-05 13:06:45

How to replace text by condition?

There is a column with such data

/upload/ammina.optimizer/jpeg-webp/q80/upload/iblock/ccf/Krasnoe-derevo_min.webp

/upload/ammina.optimizer/jpg-webp/q80/upload/iblock/ccf/Krasnoe- derevo2_min.webp

/upload/ammina.optimizer/png-webp/q80/upload/iblock/ccf/Krasnoe-derevo3_min.webp

How can I find and replace in files through search,
for example where jpeg-webp, then the extension at the end will be jpeg
If jpg-webp then at the end of Krasnoe-derevo2_min.jpg

In theory, it would be possible to replace through the search in the cells found, but the problem is that in one line there can be both png-webp and jpg-webp

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question