Formula to remove text after a coma



Do you know what is the formula to remove text after a coma?

I tried to convert the Excel formula LEFT(A1,FIND(",",A1)-1) to something like LEFT({Name of field},FIND(",","{Name of field}")-1), but without success.

Thank you for your help!


Um, that looks perfectly fine to me — that is, it does once you remove the quotation marks from around the second {Name of Field}:

    {Name of field},
        {Name of field}