I need a script that will upload an XML file from a URL, discard <item> elements based on 2 child element criteria: <price> and <discount>; then output the result as XML to a different URL.
Should be easy with Xpath, but the XML data includes additional characters ($ and %), which defeats my rudimentary knowledge as I can't apply a logic based query. Your script can remove these characters if you like - I don't need them.
Script needs to automate and schedule the entire process. Sample XML input file attached.