I am not sure on how to take an excel file and transform it into xml. But if you want to take an existing xml file and transform it into XML, then you have to create a xsl file with a looping statement and then attach the xsl file to your xml file.

Here is an example of your xml file
<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="test.xsl" ?>
<Root>...

Hello,

Is it possible to loop through an element and have it skip over certain characters so that it spits out only what you want? For example, inside the Picture tag I need to either strip out or skip over everthing before the http://protocol.
I have tried searching for examples of this and fear that there may be no solution. I have also used basic find and replace in any given editor but this is tedious and only satisfies...