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?
+16Hi @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!
+21Another 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, "(?://)(.*)"))
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.