Note: replace “URL” with column’s NAME and make sure the single quotation marks are STRAIGHT.
Hi Airtable Community,
TL;DR I’m trying to write a formula that’ll turn part of a URL into a Primary Field
Specifically, I have a list of URL’s like below. I need to separate the last bit of each URL (e.g. shopify, how to use, square vs paypal, what is credit card processing) and automate it into the Primary Field name - leaving out everything before it. The problem I’m unable to solve is that the part after the main URL is variable. For example, in https://www.usnews.com/360-reviews/credit-card-processing/what-is-credit-card-processing the emboldened part varies in each URL, making it hard to remove it with a formula
Solved! Go to Solution.
You will need to use a combination of functions. In the interest of teaching you to fish versus giving you a fish, here is the logic you need
And here are the functions you will need:
LEFT(string, howMany) will let you extract the first letter/character.
UPPER(string) will convert a string to upper case.
& will concatenate the upper case first character with the rest of the string
RIGHT(string, howMany) will let you extract all the characters at the end of the string.
LEN(string) will help you calculate “howMany” characters to put in to the
All of these functions are documented in the formula field reference.
This support article also shows how to nest functions inside each other to build more complex functions.