Change activity Id

A
ALKA REVO 👤 Member for 19 years
Planning, Scheduling & Programming Discussion
A
Arnold Puy 👤 Member for 19 years 1 month
· Permalink

Hello Revo,



Okey, can you please show me what you want to do. Say for example, you have an Activity ID = FJRA000010, then you want to change the first four letters to BLDG000010, all you have to do is to use Global Change using these Parameters:



user_text7 = SubString(Activity ID,5,10)

Activity ID = BLDG & user_text7



Or you can use this:



user_text7 = RightString(Activity ID,6)

Activity ID = BLDG & user_text7



And you can get the same result. However, before doing this always create BACKUP COPY to your current project. Just let me know and you can send it to me if ever you cannot do it. My e-mail address is [email protected] I can do it for you.



Regards,



Arnold


A
ALKA REVO 👤 Member for 19 years
· Permalink

Hi Arnold,

Thanks a lot for helping.It doesn’t sound very bright, but I am not able to define user text here. Can you please help a bit more and explain a bit more how to do it. I have never used this type of paramaeter definition before.



Kind regards

alka

A
Arnold Puy 👤 Member for 19 years 1 month
· Permalink

Hi Alka,



Try to use Global Change, choose from the following Parameter Values:



Then Parameter Is Parameter Value Operator Parameter Value

user_text7 = RightString(Activity ID,#)

user_text7 = LeftString(Activity ID,#)

user_text7 = SubString(Activity ID,#,#)

And Activity ID = LeftString(Activity ID,#) & user_text7

And Activity ID = LeftString(Activity ID,#) & user_text7

And Activity ID = SubString(Activity ID,#,#) & user_text7



Before doing this always create BACKUP COPY to your current project.





Arnold

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts