Page 1 of 1

Sort code Replace !

Posted: Wed Aug 29, 2007 12:37 am
by zootycoonvn
I have 1000 line in file txt:

1/Such as :

Apr 2008
Aug 2007
Aug 2008
Aug 2010
Dec 2008
Dec 2009
Feb 2008
Result :
04 2008
08 2007
08 2008
08 2010
12 2008
12 2009
02 2008

Code :
Search----Replace
Jan---01
Feb---02
.......
Nov---11
Dec---12
Code is very row,i want it only 1 row.

2/Such as :
Apr 2008---Good---Eat
Aug 2007---Great---Drink
Aug 2008---Happy---Play
Aug 2010---Hope---Kiss
Dec 2008---Car---like
Dec 2009---Moto---hihi
Feb 2008---Bus---Cheap

Result :
G---04 2008---Good---Eat
G---08 2007---Great---Drink
H---08 2008---Happy---Play
H---08 2010---Hope---Kiss
C---12 2008---Car---like
M---12 2009---Moto---hihi
B---02 2008---Bus---Cheap

Plzz help me.Thankz

Re: Sort code Replace !

Posted: Sat Sep 01, 2007 8:23 am
by Abacre
You have to solve the problem in two steps.

2st step:

Go to Batch replace tab, check on "Use regular expressions".
Put into the grid, search for:
(\w+ \d+---)(\w)

Replace with:
$2---$1$2

The result will be:
G---Apr 2008---Good---Eat
G---Aug 2007---Great---Drink
H---Aug 2008---Happy---Play
H---Aug 2010---Hope---Kiss
C---Dec 2008---Car---like
M---Dec 2009---Moto---hihi
B---Feb 2008---Bus---Cheap

2nd step:
Replace all months by numbers. You may uncheck "Use regular
expressions" and check "Whole Words Only".
Then you simply create a batch grid like this:

Search For:
Jan
Replace With:
01

Search For:
Feb
Replace With:
02

and so on for all 12 months.

Re: Sort code Replace !

Posted: Mon Sep 03, 2007 11:19 am
by zootycoonvn
Thanks.
But it is complex.
Have way other ?
If ex2 is :
2/Such as : find first of : xxxx
Apr 2008---like---1ood---Eat
Aug 2007---like---1rea---Drink
Aug 2008---Eat---3app---Play
Aug 2010---mary---4ope---Kiss
Dec 2008---like---2452---like
Dec 2009---like---3456---hihi
Feb 2008---like---2usy---Cheap

Result :
1---Apr 2008---like---1ood---Eat
1---Aug 2007---like---1rea---Drink
3---Aug 2008---Eat---3app---Play
4---Aug 2010---mary---4ope---Kiss
2---Dec 2008---like---2452---like
3---Dec 2009---like---3456---hihi
2---Feb 2008---like---2usy---Cheap

Re: Sort code Replace !

Posted: Mon Sep 03, 2007 11:42 am
by Abacre
I think this is almost the same case as previous. You can do it yourself.

Re: Sort code Replace !

Posted: Mon Sep 03, 2007 12:04 pm
by zootycoonvn
Roman wrote:I think this is almost the same case as previous. You can do it yourself.
Plzz help me ex a like me config.
I develop it rest require of me.
So i write question & wait u rely.


Many thanks for support from Roman.

Plzz help me it :
2/Such as : find first of : xxxx
Apr 2008---like---1ood---Eat
Aug 2007---like---1rea---Drink
Aug 2008---Eat---3app---Play
Aug 2010---mary---4ope---Kiss
Dec 2008---like---2452---like
Dec 2009---like---3456---hihi
Feb 2008---like---2usy---Cheap

Result :
1---Apr 2008---like---1ood---Eat
1---Aug 2007---like---1rea---Drink
3---Aug 2008---Eat---3app---Play
4---Aug 2010---mary---4ope---Kiss
2---Dec 2008---like---2452---like
3---Dec 2009---like---3456---hihi
2---Feb 2008---like---2usy---Cheap

Re: Sort code Replace !

Posted: Mon Sep 03, 2007 12:24 pm
by Abacre
The solution is:

Search for:
(\w+ \d+---\w+---)(\w)

Replace with:
$2---$1$2

Re: Sort code Replace !

Posted: Mon Sep 03, 2007 12:51 pm
by zootycoonvn
Thanks Roman vey much.
Best wishes !