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

    Field for Calculating and Filter


      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.