Page 1 of 1

Moving random text to end of the line.

Posted: Thu Feb 23, 2006 9:42 pm
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?

Posted: Thu Feb 23, 2006 11:13 pm
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.

Posted: Thu Feb 23, 2006 11:51 pm
by tutone
That did not work. What else should i try?

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

Posted: Thu Feb 23, 2006 11:59 pm
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.

Posted: Fri Feb 24, 2006 12:04 am
by tutone
I just sent the files. Thanks for your help.

Posted: Fri Feb 24, 2006 12:35 am
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

Posted: Fri Feb 24, 2006 1:25 am
by tutone
That said that 0 files were found as well. Does it work when you execute it using my file?

Posted: Fri Feb 24, 2006 8:20 am
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.