Help

Re: Remove Characters after comma for string fields

Solved
Jump to Solution
1364 0
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
17 - Neptune
17 - Neptune

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

3 Replies 3
TheTimeSavingCo
17 - Neptune
17 - Neptune

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!