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?
Remove Text before URL formula
+2
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}))
+5assuming Website: http://2pillarschurch.com (websites) are in field URLFIELD, in the new formula field, add this:
MID(URLFIELD,9,16000)
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.