GLOBAL CHANGE

R
Ronald Romero 👤 Member for 19 years 7 months

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

A
Alex Wong 👤 Member for 23 years 4 months

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

J
Joseph Erwin Cargason, C.E.,PSP 👤 Member for 20 years 1 month

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

A
Arthur Godbeer 👤 Member for 19 years 10 months

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"!

Forum Sponsor

Top Posters

Dimitrios Theocharidis
3 posts
MichaelFuelsC
0 posts
anwar zeb
1 posts
olva seselima
1 posts
Muhammd Muneer
0 posts
sairam
0 posts
MARAT BILYALOV
0 posts
RichTea66
0 posts
Muneer Muhammad
1 posts
Manny Onifade
5 posts