Global Change...

Hi John,



You are welcome.



i think what ronald suggested is better method.



all the best.



Manu

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,



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.