Skip to content

GLOBAL CHANGE

Likaa LikaaMember for 20 years 4 months
Created
4
1
0
HI,

I WONDER ANY BODY KNOW CAN HELP ME TO DELET THE FIRST 2 CHARICTER FROM ID ACTIVITY FOR THE WHOLE PROJECT.


THANKS.



LIKAA

4 replies

Oldest first
  1. 0
    Arthur Godbeer ·
    See pages 350/351 of the manual for general info on doing this type of thing. I think there is also a tech bulletin on this exact requirement.

    In the "Then" part of Global Change, use ACT EQ RIGHT(ACT,8) This should work for any length of Id. (If what remains is purely numeric, it will be treated as such and will be right-justified. There is a way of removing leading blanks for display purposes only. I’d have to look up how to do that.)

    Of course, as always, do a "Trial run"!
  2. 0
    Joseph Erwin Cargason, C.E.,PSP ·
    If you want to delete it manualy convert your project first into exclusive access then you can delete or change your activity ad or if you want you can export it to excel then edit it.

    joseph
  3. 0
    Alex Wong ·
    Gents

    When you add additional digit is fine, but when you delete digit from existing schedule you need to be careful of "Duplicated" activity Id

    HTH

    Alex
  4. 0
    Ronald Romero ·
    Likaa,

    You can also use other string function like SS and SUBTR
    try in the then statement ACT EQ SS(ACT,3,8), this will do as the one posted by Arthur. Try it.

    Regards,

    Ronnie

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?