Sep 08, 2022 09:29 AM
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?
Sep 08, 2022 09:41 AM
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.
Sep 08, 2022 09:45 AM
Brilliant! Thank you!
Sep 08, 2022 07:19 PM
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, "(?://)(.*)"))