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.