Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Parse a string with separation

Topic Labels: Formulas
Solved
330 1
cancel
Showing results for
Did you mean:
5 - Automation Enthusiast

Hello guys,

I have this string : DECO > OBJET DECO > AUTRE OBJET DECO
and I would like only : AUTRE OBJET DECO
so only what is after the second >.

I tried with :
RIGHT( {Catégorie}, FIND( “>”, {Catégorie} ) -1 )

RESULT was " DECO" (The last 5 characters)

I really don’t understand why only the last 5 characters.

1 Solution

Accepted Solutions
Airtable Employee

You’re getting that result because the formula is actually finding the first instance of `>`, not the last one. I would recommend using the `MID` function like the following:

``````MID(
{Catégorie},
FIND(
">",{Catégorie},
FIND(
">", {Catégorie}
)+1
)+2,
500
)
``````

This formula uses one FIND function to identify the first instance of `>`, while the second function uses that location (+1) as the starting point for the `MID` function. The `500` at the end is how many characters you want to return after `>`; it’s just set arbitrarily high to account for longer text strings, so you can adjust as needed.

Airtable Employee

You’re getting that result because the formula is actually finding the first instance of `>`, not the last one. I would recommend using the `MID` function like the following:

``````MID(
{Catégorie},
FIND(
">",{Catégorie},
FIND(
">", {Catégorie}
)+1
)+2,
500
)
``````

This formula uses one FIND function to identify the first instance of `>`, while the second function uses that location (+1) as the starting point for the `MID` function. The `500` at the end is how many characters you want to return after `>`; it’s just set arbitrarily high to account for longer text strings, so you can adjust as needed.