
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 23, 2019 03:32 AM
From this:
animals > cat > face > eyes
into
Animals/Cat/Face/Eyes
how can i do that i know the first step:
SUBSTITUTE({Category 1}, ’ > ', ‘/’) // this replaces the > into /
and then how can i use the upper case method only for the first letter of every word?
thanks for the help
please write an example code, thanks!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 29, 2019 02:38 AM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 29, 2019 03:06 AM
Modifying that setup to work in your situation is definitely doable, though the biggest issue you need to consider is how many pieces you need to capitalize. Will it always be 4, or could there be more in some cases? If more, what’s the maximum number of pieces?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 29, 2019 03:13 AM
3-8 words
example 1: nonfiction > nature > animal rights
example 2: nonfiction > technology & engineering > agriculture > animal husbandry > Test

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 29, 2019 03:21 AM
Based on those samples, which output do you want?
Option 1: only capitalize the first word in each section
example 1: Nonfiction/Nature/Animal rights
example 2: Nonfiction/Technology & engineering/Agriculture/Animal husbandry/Test
…OR…
Option 2: capitalize all words
example 1: Nonfiction/Nature/Animal Rights
example 2: Nonfiction/Technology & Engineering/Agriculture/Animal Husbandry/Test
I’ve got some thoughts on how to simplify the setup in that example base you shared that will make Option 1 a little easier. Option 2 is a lot more complex because each subsection needs individual words capitalized, including logic to find those words with or without separators.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 29, 2019 03:48 AM
Here’s a version that outputs Option 1 based on my description above, and supports up to 8 sections.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 29, 2019 06:50 AM
i need to capitalize all Words :slightly_smiling_face: )

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 29, 2019 06:51 AM
can you send me the code?
I will love you so much!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 29, 2019 07:14 AM
Here’s a link to a test base where I built the setup shown above:
I’m afraid that I don’t have time to delve into this more deeply to create Option 2. By studying this version and the one made by @W_Vann_Hall you can probably figure out how to capitalize all words in each part.
Personally, though, I would enlist the help of external tools. For example, Zapier has a “Code by Zapier” app where you can write custom code that operates on zap data. Make a zap that takes the data from your source, processes it to capitalize all words (hint: use the .title()
string method in Python) and change the separators (hint: use the .split()
and .join()
Python string methods), then feed the data into Airtable. Or pull the data from Airtable, process it, then replace the old version with the capitalized version.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 11, 2020 09:59 AM
This could now be done with the new scripting block as well. It would require manually running the script whenever new data needs to be processed, but it keeps everything inside Airtable if that’s your preference.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 29, 2021 02:04 PM
@airtableManuel You can do this with this formula:
REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE(REGEX_REPLACE({YOUR FIELD NAME}, "^a", "A"), "^b", "B"), "^c", "C"), "^d", "D"), "^e", "E"), "^f", "F"), "^g", "G"), "^h", "H"), "^i", "I"), "^j", "J"), "^k", "K"), "^l", "L"), "^m", "M"), "^n", "N"), "^o", "O"), "^p", "P"), "^q", "Q"), "^r", "R"), "^s", "S"), "^t", "T"), "^u", "U"), "^v", "V"), "^w", "W"), "^x", "X"), "^y", "Y"), "^z", "Z"), " a", " A"), " b", " B"), " c", " C"), " d", " D"), " e", " E"), " f", " F"), " g", " G"), " h", " H"), " i", " I"), " j", " J"), " k", " K"), " l", " L"), " m", " M"), " n", " N"), " o", " O"), " p", " P"), " q", " Q"), " r", " R"), " s", " S"), " t", " T"), " u", " U"), " v", " V"), " w", " W"), " x", " X"), " y", " Y"), " z", " Z")
