Help

Is this possible with Airtable formulas?

Topic Labels: Formulas
Solved
Jump to Solution
595 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Coaching_Klik
4 - Data Explorer
4 - Data Explorer

Hi there! :grinning_face_with_smiling_eyes: :wave:

Is it possible to trim input, by using the _'s ? Or is there a more clever way?

Input: John-Doe_recGQNicbCUqYIJ9s_coach-60bf663d8f264a0004816093

Output formula 1: John Doe
Output formula 2: recGQNicbCUqYIJ9s
Output formula 3: 60bf663d8f264a0004816093

Looking forward to some tips! Thankyou! :smiling_face_with_three_hearts:

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

Welcome to the Airtable community!

Yes, it is possible. I recommend using the REGEX_EXTRACT formula. I don’t have time to write up the full formulas, but this might get you started.

This will get you the first name. You will still need to substitute the - with a space character.

REGEX_EXTRACT({Field Name}, "^[^_]+")

This is the record ID, but you still need to remove the initial underscore.

REGEX_EXTRACT({Field Name}, "_rec[^_]+")

This is the last bit.

REGEX_EXTRACT({Field Name}, "[^-_]+$")

Sorry I do not have more time.

On the other hand, this information is most likely stored somewhere else in the base as individual fields. A better method would be to pull the individual items across from their initial source fields.

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto

Welcome to the Airtable community!

Yes, it is possible. I recommend using the REGEX_EXTRACT formula. I don’t have time to write up the full formulas, but this might get you started.

This will get you the first name. You will still need to substitute the - with a space character.

REGEX_EXTRACT({Field Name}, "^[^_]+")

This is the record ID, but you still need to remove the initial underscore.

REGEX_EXTRACT({Field Name}, "_rec[^_]+")

This is the last bit.

REGEX_EXTRACT({Field Name}, "[^-_]+$")

Sorry I do not have more time.

On the other hand, this information is most likely stored somewhere else in the base as individual fields. A better method would be to pull the individual items across from their initial source fields.

Thankyou @kuovonne !