Website Upgrade Incoming - we're working on a new look (and speed!) standby while we finalise the project

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Global Change...

7 replies [Last post]
Sat, 2005-12-03 10:19
John Duterte
User offline. Last seen 18 years 51 weeks ago. Offline
Joined: 3 Dec 2005
Posts: 5
Groups: Petro-Chem / Oil & Gas
Hey guys!

I’m a beginner of Primavera Project Planner. Is their anybody who can help me how to perform global changed. Like for instance I have this Activity ID.

AB0010
AB0020
AB0030
AB0040
AB0050

I want to change the first 2 digits in to CC. So, that my activity ID will become like these.

CC0010
CC0020
CC0030
CC0040
CC0050

Looking forward for your assistance. Thank you....

regards,
John D.
Top

Replies

Wed, 2005-12-14 11:56
#1
manulal inasu
User offline. Last seen 18 years 45 weeks ago. Offline
Joined: 15 Oct 2005
Posts: 52
Groups: None
Hi John,

You are welcome.

i think what ronald suggested is better method.

all the best.

Manu
Top
Wed, 2005-12-14 06:59
#2
John Duterte
User offline. Last seen 18 years 51 weeks ago. Offline
Joined: 3 Dec 2005
Posts: 5
Groups: Petro-Chem / Oil & Gas
Hi Manu!

Thanks again for your help. It’s work....


regards,

John
Top
Tue, 2005-12-13 07:59
#3
Mohd Mahd
User offline. Last seen 16 years 44 weeks ago. Offline
Joined: 13 Jul 2001
Posts: 62
Groups: None
Hi,
i was wondering, is there any problem to use copy/past? i am not using golbal change unless no other way.
Top
Tue, 2005-12-13 07:01
#4
manulal inasu
User offline. Last seen 18 years 45 weeks ago. Offline
Joined: 15 Oct 2005
Posts: 52
Groups: None
Ronald,

You are right. Thats a better method.

Manu
Top
Fri, 2005-12-09 06:32
#5
Ronald Fisher
User offline. Last seen 5 years 16 weeks ago. Offline
Joined: 3 Jun 2004
Posts: 15
Groups: Petro-Chem / Oil & Gas
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
Top
Thu, 2005-12-08 02:18
#6
John Duterte
User offline. Last seen 18 years 51 weeks ago. Offline
Joined: 3 Dec 2005
Posts: 5
Groups: Petro-Chem / Oil & Gas
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 it’s works..... once again thanks a lot

regards,
John
Top
Sun, 2005-12-04 03:07
#7
manulal inasu
User offline. Last seen 18 years 45 weeks ago. Offline
Joined: 15 Oct 2005
Posts: 52
Groups: None
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.
Top