Help

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.

concatenate formula issue

Topic Labels: Formulas
Solved
Jump to Solution
2002 2
cancel
Showing results for 
Search instead for 
Did you mean: 
JPE
4 - Data Explorer
4 - Data Explorer

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

1 Solution

Accepted Solutions
Ben_Young1
11 - Venus
11 - Venus

Hey @JPE

Give this formula a shot:

IF(
    {Course},
    REGEX_REPLACE(
        {Course},
        '"', ""
    )
)
&
IF(
    AND(
        {Instructor},
        {Course}
    ),
    " | "
)
&
{Instructor}

See Solution in Thread

2 Replies 2
Ben_Young1
11 - Venus
11 - Venus

Hey @JPE

Give this formula a shot:

IF(
    {Course},
    REGEX_REPLACE(
        {Course},
        '"', ""
    )
)
&
IF(
    AND(
        {Instructor},
        {Course}
    ),
    " | "
)
&
{Instructor}

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