multiple functions
Posted: Wed Mar 14, 2007 11:25 am
Is there a way to have a string of functions in one Calculated Field? I am creating an XML file using the text export, but there are specific characters that are not allowed in an XML file. I need to replace those characters with certain code so that they translate properly. Right now, I can replace one at a time, but really need to be able to do all of them.____I am using STRREP(FIRSTNAME,"&","&"). It works great for replacing the ampersand, but there are other characters that need addressing as well. Is STRREP the best function for what I am trying to do? There could be one, multiple, or no instances of any given character for each field.______P.S. - Any plans for adding an XML export feature in the near future?