Help

concatenate formula issue

Topic Labels: Formulas
Solved
Jump to Solution
1365 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