OK, here's the deal....
Trying to look like a hero here at work. I've got 12,000 PDFs and an XML file that references them all.
Now the fun part.
12,000 PDFs was for a stress test that failed miserably. I wanted to reduce that to 500 PDFs. Unfortunately, in the original XML file the 12,000 aren't in any sort order. So I can't just highlight the 501st record through the end of the XML and delete. :mad:
What I'd need is some way to read the XML, find the <filename>1.PDF</filename> and then rename the contents of that tag for each record, incrementally.
1.PDF
2.PDF
3.PDF
etc....
Right now it's like
5.pdf
244.pdf
5,332.pdf
makes no sense.
Think of using Excel, whereby you type 1 into one cell, 2 into the one below, and then highlight them both and drag the cells down. That incrementally changes them all the way.
I tried that method, opening the XML in Excel but since there's a .PDF tag at the end, it didn't work as expected.
Trying to look like a hero here at work. I've got 12,000 PDFs and an XML file that references them all.
Now the fun part.
12,000 PDFs was for a stress test that failed miserably. I wanted to reduce that to 500 PDFs. Unfortunately, in the original XML file the 12,000 aren't in any sort order. So I can't just highlight the 501st record through the end of the XML and delete. :mad:
What I'd need is some way to read the XML, find the <filename>1.PDF</filename> and then rename the contents of that tag for each record, incrementally.
1.PDF
2.PDF
3.PDF
etc....
Right now it's like
5.pdf
244.pdf
5,332.pdf
makes no sense.
Think of using Excel, whereby you type 1 into one cell, 2 into the one below, and then highlight them both and drag the cells down. That incrementally changes them all the way.
I tried that method, opening the XML in Excel but since there's a .PDF tag at the end, it didn't work as expected.
via International Skeptics Forum http://ift.tt/1ajsGha
Aucun commentaire:
Enregistrer un commentaire