Replace partial text, from excel

How To
,
1

Hi everyone,

I’m trying to create a flow in Make.com to modify URLs in an Excel file and update the results in another column. Here’s what I’m trying to achieve:

  1. I have an Excel file with the following columns:
  • L: Contains cells with multiple URLs separated by commas (e.g., https://example.com/old-url1.png,https://example.com/old-url2.png).
  • W: Contains a specific URL that I want to search for and replace (e.g., https://example.com/old-url1.png).
  • Z: Contains the new URL to replace the one in column W (e.g., https://example.com/new-url1.png).
  • S: Is empty and where I want to save the result of column L after applying the replacement.
  1. For each row, the flow should:
  • Take the URL from column W.
  • Search for it across all cells in column L (since a single cell can contain multiple URLs separated by commas).
  • Replace the found URL with the corresponding one from column Z.
  • Save the modified text in column S of the same row.

Example:

  • L (initial): https://example.com/old-url1.png,https://example.com/old-url2.png
  • W: https://example.com/old-url1.png
  • Z: https://example.com/new-url1.png
  • S (expected result): https://example.com/new-url1.png,https://example.com/old-url2.png

Any guidance on how to properly configure this flow in Make.com would be greatly appreciated. Thank you!

1 Like
2

Hi @Prosillas

You can try using if() and replace() functions i.e {{if(contains(L;W)=true;replace(L;W;Z))}} in column S.

Regards,
Msquare Automation - Platinum Partner of Make
@Msquare_Automation