maya Posted June 13, 2015 Report Share Posted June 13, 2015 Hi All. So i'm challenged in the logic dept and more into animation. I'm looking for a way to this: 1) I have a folder of about 100 files containing text formatted in xml. The files are for example: "Test_1.xml" to "Test_100.xml" 2) I'd like to look for the first occurrence of the tag/text <metadata> and delete all text preceding that tag. 3) Then, paste the contents of a previously copied block of xml from the clipboard (which I'll manually copy to the clipboard) into the file from the first line in the file Text.xml - So basically the clipboard text is replacing the previously deleted block in Test_1.xml. 4) Once that is done, the macro will go down to the next file in the folder and repeat steps 2 and 3 until it reaches the end of the folder. (file Test_100.xml) I don't mind sending a paypal fiver or more, and would be happy if the macro itself is posted here for the community. Kind Regards. Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.