![Lisa_H Lisa_H](https://community.airtable.com/legacyfs/online/avatars/2X/6/6aa674d64da4fa9bbe646ec168b73a3a74cbdf8c.png)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 05, 2025 10:54 AM
Hi,
I have one column in my Jobs Table that pulls the Job address from my Table of Customers, its a Formula and seems to work fine it puts the correct Job address into the Jobs Table if the customer has a different Mailing address, it looks like this:
I have a second column in the Jobs Table that I need to JUST have the City Name appear in. I have tried to write the formula, and it just returns an Error Message, it looks like this:
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 05, 2025 04:37 PM
Assuming that there will only be one comma in the job address column as shown -- right before the city -- this should work:
IF({Job Address},
SUBSTITUTE(
REGEX_EXTRACT({Job Address}, "[^\\s]+,"),
",",
""
)
)
![Lisa_H Lisa_H](https://community.airtable.com/legacyfs/online/avatars/2X/6/6aa674d64da4fa9bbe646ec168b73a3a74cbdf8c.png)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 06, 2025 01:34 PM
Thank you! I will give it a try!
![](/skins/images/FE00829FDD2AE889FAB731D8F02A8942/responsive_peak/images/icon_anonymous_message.png)