Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

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.

GLOBAL CHANGE

4 replies [Last post]
Tue, 2006-12-12 00:59
likaa likaa
User offline. Last seen 14 years 37 weeks ago. Offline
Joined: 9 Jun 2006
Posts: 14
Groups: None
HI,

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


THANKS.



LIKAA
Top

Replies

Thu, 2007-03-08 07:58
#1
Ronald Romero
User offline. Last seen 1 year 44 weeks ago. Offline
Joined: 13 Nov 2006
Posts: 63
Groups: Civil Engineering
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
Top
Tue, 2007-01-09 19:20
#2
Alex Wong
User offline. Last seen 12 years 13 weeks ago. Offline
Joined: 12 Feb 2003
Posts: 874
Groups: TILOS
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
Top
Sun, 2007-01-07 03:45
#3
Joseph Erwin Carg...
User offline. Last seen 8 years 10 weeks ago. Offline
Joined: 7 May 2006
Posts: 33
Groups: GPC Qatar, Pinoy Planning Planet Community
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
Top
Tue, 2006-12-12 03:13
#4
Arthur Godbeer
User offline. Last seen 15 years 49 weeks ago. Offline
Joined: 24 Jul 2006
Posts: 127
Groups: None
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"!
Top