Integromat Search Airtable module - Formula to find 2 possible url finishing by "/" or not by "/"

[William_Bet]

Hey there !

I’m struggling to automatically update some records that are in airtable bases.

I’ve got a flow into a google sheet with clean url, that I would match to same url into Airtable (but those may not be all clean.)

In Google sheet my urls are without “/” at the end

In Airtable 80% of urls are with " / " at the end, 20 % not.

Do you know how should I write my formula to search both case each time and update the record in question ?

thank you in advance !
Will

[Per_Carlen]

Hi @William_Bet !

William_Bet:

…to search both case each time and update the record in question?

What should the formula search for and what do you want the output to be? Do you want the formula to remove the backslash at the end of the URL if there is one? If so, here’s a formula for that:

IF(RIGHT(URL, 1) = "/", LEFT(URL,LEN(URL)-1), URL)

Change “URL” to the name of your URL field.