Removing the tail end from URLs

[Pearl_Adams_Cli]

I have about 400 records that have URLs with standard https://

However, in order to use these with our email marketing merge tags, I need them all to not include the https:// pre-fix within the URL.

Is there a way to update all these records at once instead of manually?

[Vivid-Squid]

Hi @Pearl_Adams_Clinic_P,
Might be even quicker to just use a formula field.

MID(URL, 9, LEN(URL))

The MID() formula will extract text from a given starting point to a given ending point. We know we want to start after https:// that is 8 characters, so we start on the 9th character. Then to find the last character we count the total number of characters with LEN() in the URL.

[Pearl_Adams_Cli]

Vivid-Squid:

MID(URL, 9, LEN(URL))

Brilliant! Thank you!

[Justin_Barrett]

Another formula option is to use a regular expression. This would be handy in case any of the URLs are “http” instead of “https”.

IF(URL, REGEX_EXTRACT(URL, "(?://)(.*)"))