8 Replies Latest reply on Oct 7, 2015 11:09 AM by erolst

    Field for Calculating and Filter

    kimbakat

      I have to create two fields that contains the name of a project.

      One of these fields has to have certain characters removed.

       

      I already have this in the calculation of a field called PROJECT NAME

       

      Filter("~!@#$%^&*()<>,.:'=*/";" ")

       

      But what I need to add in this calculation is the text from another field where we type in the full project name with the characters.

      So I only have to have type this in once.

       

      The reason for two is that while we like to use characters on invoices...I need to export it as part of a filename. Those characters are not recognized on import into AccountEdge software.

       

      How do I add the other field into this Filter calculation above?  I looked through other examples but could not find my situation in the forums.