Skip to main content

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?

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}))
assuming Website: http://2pillarschurch.com (websites) are in field URLFIELD, in the new formula field, add this:
MID(URLFIELD,9,16000)

Reply


Terms & Conditions