Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

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.

Changing Activity ID inbetween using Global Change

2 replies [Last post]
Sat, 2010-05-15 00:10
Haresh Jayanth
User offline. Last seen 6 years 8 weeks ago. Offline
Joined: 24 Aug 2006
Posts: 219
Groups: Building Information Modelling, GPC Qatar
Suppose i have around 50 activities with activity ID SUTSGF001,SUTSGF002....and so on.....
I want to change all activities in that WBS to SUTSFF001, SUTSFF002....and so on..i.e to replace "GF" to "FF" in the middle using Global change.......What is condition i have to apply....
Top

Replies

Sat, 2010-05-15 05:26
#1
Rodel Marasigan
User offline. Last seen 19 hours 25 min ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Haresh,
In addition to Pinan response below is another Global Change parameter that you can use.
If
where WBS is under (select the wbs containing activity to change)
Then
Activity ID = SUTSFF & RightString(Activity Id,3)

In this case it will limit only on WBS stated and not all activity with SUTSGF.
Top
Sat, 2010-05-15 04:20
#2
PINAN T.
User offline. Last seen 5 years 43 weeks ago. Offline
Joined: 20 Jul 2007
Posts: 102
Groups: Pinoy Planning Planet Community
The simplest is Replace Function (Control R), Find GF and Replace with FF


By Global Change, You can try a simple one

If
Activity Id starts with SUTSGF

Then
Activity Id EQ SUTSFF & rightstring(activity id,3)
Top