Field for Calculating and Filter

Discussion created by kimbakat on Oct 5, 2015
Latest reply on Oct 7, 2015 by erolst

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.