Help

Batch updating URLs to remove https://

Topic Labels: Extensions
1332 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Pearl_Adams_Cli
4 - Data Explorer
4 - Data Explorer

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?

3 Replies 3

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.

image

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

Screen Shot 2022-09-08 at 7.18.46 PM