Global Change...
Forum Sponsor
Top Posters
Dimitrios Theocharidis
3 posts
MichaelFuelsC
0 posts
anwar zeb
1 posts
olva seselima
1 posts
Muhammd Muneer
0 posts
sairam
0 posts
MARAT BILYALOV
0 posts
RichTea66
0 posts
Muneer Muhammad
1 posts
Manny Onifade
5 posts
Hi John,
You are welcome.
i think what ronald suggested is better method.
all the best.
Manu
Hi Manu!
Thanks again for your help. Its work....
regards,
John
Hi,
i was wondering, is there any problem to use copy/past? i am not using golbal change unless no other way.
Ronald,
You are right. Thats a better method.
Manu
Even better, why not try this:
Using the Substring() function and the Ampersand sign, type in the second box down from the top
ACT EQ CC & SS(ACT,3,8)
works all the time
Hi Manu,
I really appreciated you immediate response for my question. Right after this reply I will try that solution and will inform you if its works..... once again thanks a lot
regards,
John
Hi,
I shall give you a solution for this.
It is a simple one, which came to my mind as soon as I found your question. Normally I do this type of changes after exporting the file to excel.
The condition for my solution is that your Activity Ids should be having same number of characters.
Go to Tools>Global change
The logic is
IF Activity ID contains AB
Then New Activity ID = CC+ Third to last characters of the present activity ID.
Assuming that your Activity ID has 6 characters, it should be
IF ACT CN AB
THEN ACT EQ CC & RIGHT(ACT,4)
Everything except RIGHT(ACT,4), you will get from the drop down list. RIGHT(ACT,4) you will have to type.
Regards,
Manu.