Quick Find & Replace Question!

Something Vague · May 5, 2009

Hi, I have a XML page here. Basically, I need to change the AA! (1) for every file to (2) all the way through to (2611). Is there any Find and Replace formula I could use, instead of doing this manually? Or, some simple PHP script I could incorperate into this XML page? I would hate to have to waste 5 hours editing these numbers...

:loveyou:

PHP:

<?xml version="1.0" encoding="UTF-8"?>
<simpleviewerGallery maxImageWidth="480" maxImageHeight="480" textColor="0xFFFFFF" frameColor="0xffffff" frameWidth="20" stagePadding="40" thumbnailColumns="3" thumbnailRows="3" navPosition="left" title="SimpleViewer Title" enableRightClickOpen="true" backgroundImagePath="" imagePath="" thumbPath="">
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (2).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (3).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (4).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (5).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (6).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (7).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (8).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (9).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>

<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>

<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>

<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>

<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>

<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>

<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>

<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>
<image>
	<filename>AA! (1).jpg</filename>
	<caption>Free Avatars!/caption>	
</image>

</simpleviewerGallery>

BeZazz · May 5, 2009

I'm half asleep so I may be missing something obvious but cant you just use the replace function of a text editor?

Something Vague · May 5, 2009

Absolutely, but, I need to replace each number with a something different. So I would be using the replace function about 2600 times.

Each (1) needs to be replaced with (2) then (3) then (4) etc

BeZazz · May 5, 2009

Ahh ok.

If you haven't found the answer by tomorrow (currently 3:35am here) and still looking for a way to do it. I will write up some php for you. Just PM me if interested.

Something Vague · May 5, 2009

Thanks, I really appreciate that

qbert220 · May 5, 2009

Code:

<?xml version="1.0" encoding="UTF-8"?>
<simpleviewerGallery maxImageWidth="480" maxImageHeight="480" textColor="0xFFFFFF" frameColor="0xffffff" frameWidth="20" stagePadding="40" thumbnailColumns="3" thumbnailRows="3" navPosition="left" title="SimpleViewer Title" enableRightClickOpen="true" backgroundImagePath="" imagePath="" thumbPath="">
<?php

for ($i = 1; $i <= 2611; $i++)
{
    echo '<image>
    <filename>AA! ('.$i.').jpg</filename>
    <caption>Free Avatars!/caption>
</image>
';
}
?>
</simpleviewerGallery>

If this is saved in a file ending with .php it should do what you want.

If you need to use a different file extension, you'll need to make a change to your .htaccess file to use the PHP interpreter. For example:

Code:

RemoveHandler .xml
AddType application/x-httpd-php .xml

Something Vague · May 5, 2009

Thanks so much! I'm going to try this right now. I will post back the results

---------- Post added at 02:16 PM ---------- Previous post was at 02:10 PM ----------

I edited gallery.xml with the code you wrote, and added the .htaccess in the root but it essentially acts as if there are no images in the gallery at all.

I would only assume this is because of the whole PHP code being in an XML file

qbert220 · May 5, 2009

Is the XML file being processed by the web server? If not, rename the file so that it ends with .php, add the following to the beginning:

Code:

<?php header("Content-Type: plain/text"); ?>

then visit it in a web browser. You should then see the XML, which you could copy and paste into the XML file.

Peter · May 5, 2009

qbert220 that is not going to work properly. For example on the 1st run $i is going to be 1, you will replace 1 with 2, on the 2nd run $i is going to be 2.

Guess what is going to happen, the 1 you just replaced with 2 will now be replaced with 3.

You should start with 2611 and work your way down instead.

qbert220 · May 5, 2009

Peter said:
qbert220 that is not going to work properly. For example on the 1st run $i is going to be 1, you will replace 1 with 2, on the 2nd run $i is going to be 2.

Guess what is going to happen, the 1 you just replaced with 2 will now be replaced with 3.

You should start with 2611 and work your way down instead.

Then I must have misunderstood. I was not intending my code to run multiple times. I was trying to generate the output I thought the OP wanted:

Code:

<?xml version="1.0" encoding="UTF-8"?>
<simpleviewerGallery maxImageWidth="480" maxImageHeight="480" textColor="0xFFFFFF" frameColor="0xffffff" frameWidth="20" stagePadding="40" thumbnailColumns="3" thumbnailRows="3" navPosition="left" title="SimpleViewer Title" enableRightClickOpen="true" backgroundImagePath="" imagePath="" thumbPath="">
<image>
    <filename>AA! (1).jpg</filename>
    <caption>Free Avatars!/caption>    
</image>
<image>
    <filename>AA! (2).jpg</filename>
    <caption>Free Avatars!/caption>    
</image>
<image>
    <filename>AA! (3).jpg</filename>
    <caption>Free Avatars!/caption>    
</image>
<image>
    <filename>AA! (4).jpg</filename>
    <caption>Free Avatars!/caption>    
</image>

...

<image>
    <filename>AA! (2611).jpg</filename>
    <caption>Free Avatars!/caption>    
</image>

</simpleviewerGallery>

Peter · May 5, 2009

Sorry ignore my last post. I forgot to notice you were in fact echo'ing the data.

Something Vague · May 7, 2009

I tried your suggestion again, however it still did not work. I am completely puzzled! Instead of reading each file, maybe I could just find a way to automatically add the entire folder. I feel that might be harder to code.

Michael · May 7, 2009

It's easier to just write a script to rebuild the file, instead of trying to correct the file.

http://dnmedia.com/cwn_xml.xml

Something Vague · May 7, 2009

Michael, you just blew my mind. Thank you so much! And thank you qbert220 and Peter too, I really appreciate the efforts! Amazing!

Quick Find & Replace Question!

Established Member

VIP Member

Established Member

VIP Member

Established Member

Established Member

Established Member

Established Member

VIP Member

Established Member

VIP Member

Established Member

NameBio.comTop Member

Established Member

Boomerang.co

MedDirect.com

reddragon.com

Strove.com

revue.co

biznethome.com

BitRewards.com

Emo.com

BroadPath.com

Terafab.com

We're social

Boomerang.co

MedDirect.com

reddragon.com

Strove.com

revue.co

biznethome.com

BitRewards.com

Emo.com

BroadPath.com

Terafab.com

Pinned

Appreciation

Preference

Appreciation

Upvoting

Agreement

Answers

Decisions

Relevance

Reaction

Facial expressions

Vocal expressions

Status

Workflow

Clarification

Feeling

Sympathy