
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 08, 2022 01:09 PM
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
This is an example of what I am trying to achieve
Thank you in advance
Matt
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 08, 2022 08:17 PM
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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 09, 2022 10:54 AM
Something along the lines (untested)...
IF(FIND(',',{field name}&''),
LEFT(FIND(',',{field name}&'')-1,{field name}&''),
{field name}&''
)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 08, 2022 08:17 PM
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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 09, 2022 10:54 AM
Something along the lines (untested)...
IF(FIND(',',{field name}&''),
LEFT(FIND(',',{field name}&'')-1,{field name}&''),
{field name}&''
)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 11, 2022 10:35 AM
well that works just fine, thanks a lot!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 18, 2024 04:03 PM - edited ‎Nov 18, 2024 04:04 PM
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
