Change activity Id

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

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

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 p3-fer@sixco.ae I can do it for you.

Regards,

Arnold