Skip to main content

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?

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.



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.




Brilliant! Thank you!


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, "(?://)(.*)"))


Reply