multiple functions
-
- Posts: 6
- Joined: Tue Oct 10, 2017 12:44 pm
multiple functions
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?
-
- Posts: 6
- Joined: Tue Oct 10, 2017 12:44 pm
=> RE: multiple functions
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.