The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.
‎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:
‎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]+,"),
",",
""
)
)
‎Feb 06, 2025 01:34 PM
Thank you! I will give it a try!