General discussions about Advanced Find and Replace
-
tutone
- Posts: 12
- Joined: Thu Feb 23, 2006 9:34 pm
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.
-
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.
-
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
-
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.