Globally Changing WBS and Act ID for new project
Forum Sponsor
Top Posters
Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts
Rodel and Ferdinand thank you for your help. Rightstring worked.
hi rodel
thanks for that
i thought you are using a different setting
Ferdinand,
Thanks, I just run again the global change although different criteria and you are correct. RightString is the correct function to use. Im rushing something and forgot to check which one I used.
hi rodel
i followed the global specs as posted activity id eq yyy & leftstring(activity id,8)
the result with me is showing YYYXXX-XX-N
if i will use rightstring i will get YYY-XX-NNNN
Ferdinand,
Extract and remove is the same. Retain means remain or left behind.
Why you get an error? Maybe you’re not following the criteria? I just try the exercise to make sure and it works. I’m definitely correct using leftstring and not rightstring.
but if i will try that, i will get error
as per HELP
leftstring means "Extracts ??? characters, beginning with the first character in the Activity Name field" - that means i will extract XXX.....
and rightstring means "Extracts ??? characters, beginning with the last character in the Activity Name field"
Hi Ferdinand,
LeftString is removing character from left and retaining right.
RightString is removing character from right and retaining left.
Therefore LeftString is correct. Try the exercise and let me know if I’m wrong or not. Thanks
hi rodel
i think should be rightstring function
Bobby,
After copying the Project you can change the first 3 character by pressing ctrl+r (Replace Command). Click the Activity ID column and press Ctrl+R. Type 3 character that need to replace on Find What text box and enter the 3 character to use on Replace with text box. Click Replace first to check whether it is responding correctly and if happy click replace all.
Alternatively you can use global change as shown below.
You have to count number of character from right to left that you want to retain.
Ex: XXX-XX-NNNN = 8