Remove First Two Lines in XML using XML Application.ExportXML (1 Viewer)

hoychep · Jun 12, 2014

Hi,

I am using Application.ExportXML vba Function in MS Access 2010 and I want to remove the first two lines on my XML File

<?xml version="1.0" encoding="UTF-8"?>
<dataroot xmlnsd="urn:schemas-microsoft-comfficedata" generated="2014-06-12T13:08:16">
<eparcelorder>
<workorderno>20177569</workorderno>
<ArticleNumber>7HB0002108010225</ArticleNumber>
<serviceLevelNo>26</serviceLevelNo>
<shippeddate>2014-03-19T00:00:00</shippeddate>
</eparcelorder>
</dataroot>

will this possible from the function that I am using?

Thanks!

gemma-the-husky · Jun 12, 2014

obviously once you snip0 off the 2 lines, you won't have a valid xml file

if you are only exporting a "snippet", I would be inclined to generate the file manually. otherwise i expect you will have to process the completed file to remove the first 2 rows.

Rx_ · Jun 13, 2014

http://www.access-programmers.co.uk/forums/showthread.php?t=242332
Here is a short tip I posted in that regard. Further down there is another link to a good post. http://www.access-programmers.co.uk/forums/showthread.php?t=264297
That I posted another link...
Hopefully that might help a little. Please let us know if it did or didn't help.

Remove First Two Lines in XML using XML Application.ExportXML (1 Viewer)

hoychep

New member

gemma-the-husky

Super Moderator

Rx_

Nothing In Moderation

Similar threads

Users who are viewing this thread