Help for Global change in P6
Forum Sponsor
Top Posters
Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts
Did you try edit>replace!!
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
Hi
Why dont 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
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
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.
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
Exoprt the project into excel, change the activity id, then import back into primavera.
Hi Girish,
try to play around with the given Modify Activity IDs example of P6. You can you this function to extract text from you Activity ID which are Substring, Rightstring and Leftstring.