Page 1 of 1

multiple functions

Posted: Wed Mar 14, 2007 11:25 am
by Jay_(Guest)
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?

=> RE: multiple functions

Posted: Wed Mar 14, 2007 1:44 pm
by Jay_(Guest)
I just noticed that the post mistook part of my command as an emoticon. It should say STRREP(FIRSTNAME,"&","amp;").________Note: I know that the syntax for the "amp;" isn^t exactly correct, I just can^t get it to post exactly as I put it in. The forum must be translating my XML script.