Globally Changing WBS and Act ID for new project

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

hi rodel

i think should be rightstring function

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

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"

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.

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,
Thanks, I just run again the global change although different criteria and you are correct. RightString is the correct function to use. I’m rushing something and forgot to check which one I used.

hi rodel

thanks for that

i thought you are using a different setting

Rodel and Ferdinand thank you for your help. Rightstring worked.