concatenate formula issue

Question

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

Ben_Young1 · Accepted Answer

Hey @JPE! Give this formula a shot:IF(    {Course},    REGEX_REPLACE(        {Course},        '"', ""    ))&IF(    AND(        {Instructor},        {Course}    ),    " | ")&{Instructor}

JPE · Answer

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

concatenate formula issue

1 Attachments

2 replies

1 Attachments

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded