Moving random text to end of the line.

General discussions about Advanced Find and Replace
Post Reply
tutone
Posts: 12
Joined: Thu Feb 23, 2006 9:34 pm

Moving random text to end of the line.

Post by tutone »

I have data that looks something like this:

december1998.htm/e%20
september1997.htm/e%20
october1996.htm/e%20

I need to make it look like this:
1998.htm/e%20december
1997.htm/e%20september
1996.htm/e%20november

basically the random month in front of the random year needs to be moved to after the %20

Any ideas?

Abacre
Site Admin
Posts: 1223
Joined: Mon Jan 31, 2005 5:32 pm

Post by Abacre »

Go to Batch replace tab, check on "Use regular expressions".
Put into the grid, search for:
([a-zA-Z]+)(\d+\.htm/e%20)

Replace with:
$2$1

That's all I verified it works perfectly.
Kind regards,
Abacre Limited
http://www.abacre.com
support@abacre.com

tutone
Posts: 12
Joined: Thu Feb 23, 2006 9:34 pm

Post by tutone »

That did not work. What else should i try?

It tells me that it found 0 files in x seconds.

Abacre
Site Admin
Posts: 1223
Joined: Mon Jan 31, 2005 5:32 pm

Post by Abacre »

The provided regular expression works.
We verified it.

Please send to support@abacre.com default.cfg file located in
C:\Program Files\Advanced Find and Replace
and one of your sample files.

We will send you then correct default.cfg with ready to use
configuration.
Kind regards,
Abacre Limited
http://www.abacre.com
support@abacre.com

tutone
Posts: 12
Joined: Thu Feb 23, 2006 9:34 pm

Post by tutone »

I just sent the files. Thanks for your help.

Abacre
Site Admin
Posts: 1223
Joined: Mon Jan 31, 2005 5:32 pm

Post by Abacre »

In fact we did not see any occurence of htm/e%20
I mean text between htm/ and %20 maybe variable.

Therefore try the following expression:

Search for:
([a-zA-Z]+)(\d+\.htm.*%20)

Replace with:
$2$1
Kind regards,
Abacre Limited
http://www.abacre.com
support@abacre.com

tutone
Posts: 12
Joined: Thu Feb 23, 2006 9:34 pm

Post by tutone »

That said that 0 files were found as well. Does it work when you execute it using my file?

Abacre
Site Admin
Posts: 1223
Joined: Mon Jan 31, 2005 5:32 pm

Post by Abacre »

Yes, I tried execute it on your file. It found 308 occurrences.
So I am sending you default.cfg file by private email with
screenshots.
Kind regards,
Abacre Limited
http://www.abacre.com
support@abacre.com

Post Reply