Help for Global change in P6

Hi Girish,

try to play around with the given Modify Activity ID’s example of P6. You can you this function to extract text from you Activity ID which are Substring, Rightstring and Leftstring.

Exoprt the project into excel, change the activity id, then import back into primavera.

Hi Oliver

Thanks but this will not work as i have the logic already defined and by what you are telling me will only create new id in primavera.

I wanted to know the steps for adding a charecter in fornt of the activity ID using Global change.

Can any one give me the steps.

Thanks

Export the project file into excel.

Copy the activity id column into ’column B’ in a new spreadsheet.

In ’column a’ put the prefix you want to put in front of your activity id.

In ’colum c’ type the formula =’column a’&’column b’

Drag this down so that it is done for every activity.

Copy ’column c’ and paste special values back into the exported project file.

Save it, then import back into primavera.

Export along with the relationships, you will have 2 sets of activities when you import back, delete the first set by fitering/sorting.

Hope this works

Hi

Why don’t you simply try:
IF: Your condition / filter or leave blank if for all activities
Then: "Activity ID" = X (i.e. the character you want to add) & "Activity ID"

Dieter

Thanks Guys

Appericiate all the help. Any way found out how to do it the easiest way in 2 minutes by using global change
SubString(Parameter,#,#) function

Did you try edit>replace!!