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.
Jun 08, 2023 08:24 AM
Hi everybody I am new to airtable and trying to put a class scheduling together. I have mostly been using the template and learning through trial and error. Now I have produced a weird error that does not seem to impact the functionality but is very annoying.
I am using the formula
CONCATENATE(Course, " | ",{Instructor})
and it gives me the correct result (e.g. 100:Contract Essentials | Kevin)
but all results are now between "" (e.g. "100:Contract Essentials | Kevin")
where previously the resulting line did not display ""
So now I have a number of rows without "" and all new data has the ""
Any idea what I should do? any help would be appreciated
Solved! Go to Solution.
Jun 08, 2023 09:03 AM
Hey @JPE!
Give this formula a shot:
IF(
{Course},
REGEX_REPLACE(
{Course},
'"', ""
)
)
&
IF(
AND(
{Instructor},
{Course}
),
" | "
)
&
{Instructor}
Jun 08, 2023 09:03 AM
Hey @JPE!
Give this formula a shot:
IF(
{Course},
REGEX_REPLACE(
{Course},
'"', ""
)
)
&
IF(
AND(
{Instructor},
{Course}
),
" | "
)
&
{Instructor}
Jun 08, 2023 11:15 AM
Hi Ben, thank you, thank you, thank you. I would have never been able to do that without your help. So very much appreciated! Have a great day