Help

Re: Remove Text before URL formula

622 0
cancel
Showing results for 
Search instead for 
Did you mean: 
gospelsoulcare
4 - Data Explorer
4 - Data Explorer

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 2
sohail
Airtable Employee
Airtable Employee

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