Going to make another request on here for anyone who has done this…
I’m trying to look through characters in the records in one of my columns (it’s a combination of letters and numbers), and I’m trying to get rid of the letters so only numbers remain...
Hello Airtable community. I’m playing around with the formula field reference, and I’m not finding exactly what I’m looking for. I have a long text field, where I’m collecting messages. I’m basically trying to extract key words out of it and save tho...
W_Vann_Hall:
LEFT(full_name, SEARCH(" ",full_name)-1)
I was playing around with this for my own purposes, and came up with this. If you have very clean first and last name, the function below can be used to get last name.
RIGHT(fullname, LEN(f...
I found a solution based off a solution to a previous post. I’m sharing it below in case it helps someone else at some point. This accounts for some (but not all) special characters. Someone could take this if they need it, and add additional charact...
Thanks @JonathanBowen. This is a start! Yes, the case where I have more than 1 color, or two dogs in a sentence is still an issue, but I can save that for a next step. Much appreciated!
Matt
