Skip to content
ProjectControls.com
Primavera Project Planner - P3

Global Change...

In the Open Standard
John DuterteMember for 20 years 10 months
Created
7
3
0
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.
Save Follow Follow forum Report
Reply New topic

7 replies

Oldest first
  1. 0
    Manulal Inasu ·
    #1
    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.
    Report
  2. 0
    John Duterte ·
    #2
    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
    Report
  3. 0
    Ronald Fisher ·
    #3
    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
    Report
  4. 0
    Manulal Inasu ·
    #4
    Ronald,

    You are right. Thats a better method.

    Manu
    Report
  5. 0
    Mohd Mahd ·
    #5
    Hi,
    i was wondering, is there any problem to use copy/past? i am not using golbal change unless no other way.
    Report
  6. 0
    John Duterte ·
    #6
    Hi Manu!

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


    regards,

    John
    Report
  7. 0
    Manulal Inasu ·
    #7
    Hi John,

    You are welcome.

    i think what ronald suggested is better method.

    all the best.

    Manu
    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?