Skip to main content

Remove Text before URL formula

  • March 29, 2024
  • 2 replies
  • 35 views

Forum|alt.badge.img+2

I am trying to figure out how to create a formula that would remove the text before a URL in a field.

Example:

Website: http://2pillarschurch.com

How do I remove the Website: portion so it just shows the URL?

2 replies

Forum|alt.badge.img
  • New Participant
  • March 29, 2024

You could do this a number of different ways. Easiest thing would be to create a new field that uses a formula to remove the "Website:" part. 

So if you have a field that has "Website: https://airtable.com" and is named "Website Info", create a new field that you name "URL" or something like that and use this formula: 

 

 

MID({Website Info}, FIND("http", {Website Info}), LEN({Website Info}))

seferiannie
Forum|alt.badge.img+5
  • Participating Frequently
  • April 1, 2024
assuming Website: http://2pillarschurch.com (websites) are in field URLFIELD, in the new formula field, add this:
MID(URLFIELD,9,16000)