Mar 24, 2021 10:06 AM
I have a field that captures the URL for a webpage, but some URLs contain extra parameters after the .html part of the string.
How can I remove anything after the .html for those records but not have a blank cell if the URL does not contain parameters after .html?
I’d like a formula so that new field displays the URLs, just trimming the ?utm… part where needed:
https://www.test.com/page3.html?utm_campaign=hc-sc
https://www.test.com/page2.html
I figured out the trimming part using this formula, but not how to display URLs where there is no ?
LEFT({URL}, FIND("?", {URL}) -1)
Thanks!
Solved! Go to Solution.
Mar 24, 2021 10:23 AM
How about checking for the presence of the ? before providing a return value:
IF(
FIND("?", {URL}),
LEFT({URL}, FIND("?", {URL}) -1),
{URL}
)
Mar 24, 2021 10:23 AM
How about checking for the presence of the ? before providing a return value:
IF(
FIND("?", {URL}),
LEFT({URL}, FIND("?", {URL}) -1),
{URL}
)
Mar 24, 2021 10:26 AM
Amazing. Thank you so much!