Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Remove Characters after comma for string fields

Solved
Jump to Solution
2499 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Matteo_Saporett
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello Airtable world,

I need help with a formula. I have a look up field with many options. All of these options share the same data for some field e.g. Pick Up Location.

In this case, I have 1 record with 2 options (lookup field) and the look up field extracts: Montreal, Montreal.

Is there a formula I can use to only keep what is before the first comma when working strings

Matteo_Saporett_0-1670533707555.png

This is an example of what I am trying to achieve

Thank you in advance

Matt

 

2 Solutions

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

Hm, not sure what your data setup's like, but maybe you could look into using a rollup field with the formula `ARRAYUNIQUE(values)` as well

See Solution in Thread

augmented
10 - Mercury
10 - Mercury

Something along the lines (untested)...

IF(FIND(',',{field name}&''), 
LEFT(FIND(',',{field name}&'')-1,{field name}&''),
{field name}&''
)

 

See Solution in Thread

4 Replies 4
TheTimeSavingCo
18 - Pluto
18 - Pluto

Hm, not sure what your data setup's like, but maybe you could look into using a rollup field with the formula `ARRAYUNIQUE(values)` as well

augmented
10 - Mercury
10 - Mercury

Something along the lines (untested)...

IF(FIND(',',{field name}&''), 
LEFT(FIND(',',{field name}&'')-1,{field name}&''),
{field name}&''
)

 

well that works just fine, thanks a lot!

Can you help me do the same for Los Angeles (hollywood)? I need to remove everything including and after the "(" in "(hollywood)"

So my goal is to make Los Angeles (hollywood) --> Los Angeles