Wildcards for Global Change statements

Kevin,



Your advise is timely and precious to me. It worked out. As I do not like using mouse much, I tried Control+X and Control+V Keys as we were using in P3. This also worked well and thanks for saving my time!



Cheers, Amar.

Amar



I might be misunderstanding you but it sounds like you are trying to fill down (fill cell) rather than dragging a set of activities together.



Select a set of activities, move your mouse pointer to the left of the screen so that a small square appears with the pointer. Then click and drag those activities and drop them onto the correct Location bar. I do this often with activities grouped by Work Order and Phase, so that the activities keep the same work order number but need to be in a different project phase.



Cheers

Kevin,



This is what exactly I am doing. But As soon as you enter the first cell, the layout gets organized automatically.



I need to set something like "reorganize automatically" to off. But I do not know where to set that or what is the equivalent of "reorganize automatically" in this Version.



Cheers, Amar.

Amar



Another way is to group your activities by Area and Location. Ensure at least 1 activity with the Area1 code also has the Location1 code assigned.



Then select the activities that are in Area1 but not in Location1, and drag them into the Location1 band.



This drag and drop functionality works in V4.1, hopefully it still exists in V5.0.



Regards

Mario, Now I have around 15 major Projects and 140 Minor Projects to be converted to V5 from V3 (Version 3.0 / 3.1)



All the projects in V3 are created by different users with different activity codes for the more or less same groups of activities.



Now I am trying to streamline Activity Code.



Once I convert all projects, then this feature many not be required by me.



Thanks, Amar.

Hi Guys,



In V5 it can be done fairly simply, but as I skipped the P3ec phase I am speculating.



Try creating three user defined text fields, into the first replace it with the activity id’s, in the second fill it with 0’s, then try and combine these in the third field (as in cocatenation), and if this is successful just replace the activity id’s wth the third field. This is how I would have done it in the old way. Otherwise, after replacing the first user defined field try filling the second field with user field 1 .and. "0"

Worth giving a bash. It is simpler trying to play in user defined text fields, than with the id field, and then replace the id field with the user field, and it ensures that relationship and resource will automatically be updated.



Hope this is of some assistance.



Regards

Philip

David, Sorry, It works with other filed like activity name, Activity id etc.



But it is not working in Activity Code Field.



Any Suggestions please?

David, I am using Version 5. DO you think this is possible in version 5. I tried but it does not work. Can you please explain me again? Thanks in advance. Amar.

Have you considered using the "replace" function instead of global change. It is very fast and effective.



Select the field that you wish to edit, select edit/Replace then enter values. It is foolproof and easy to use. Also works with activity ID’s. There are only a few limitations on the fields that it works in.

Thanks, Presently I am doing One at a time. I have lot of changes to make. I am just thinking how to do quicker and in easier way. I mean to say, I wish to do global change for two if conditions at a time. Your Example is also okay with me but I wish to do both conditions at a time using sinle global change ie When England>London and When America>NY type

Mario,



In Ver 5 (or V5 to be cute) how to use global change for the following.



I have area and location as activity codes



Area Values Eg:

Area 1

Area 2

Area 3



Location Values Eg:

Location 1

Location 2

Location 3



Now Using Global change how to make



If Area=Area1 then Location=Location1

If Area=Area2 then Location=Location2

If Area=Area3 then Location=Location3



I wish to do this in one shot and without using excel or import and export.



Can you suggest something similar to if, elseif, then.. type or similar one..

If you can’t do it in P3, do it in Excel!



As Raja suggested in a different thread: “Create new Column using Custom Data item and u name it as "ACT_ID2", Then open your new column "ACT_ID2" now u can create your new ACT ID. Thats mean u have two activity ID(Original and Dummy). If u want to change the Original act id with dummy use global change before that tick exclusive (goto File Open)if not the Act ID cannot be change.”



After inputting one or two dummy IDs, export them to Excel including the existing IDs. In Excel, do the editing as per below:



For example you want to change C0123 to C00123.



(1)Extract the leftmost character of the existing ID by using the “Left()” function.

(2)Extract the mid-character of the existing ID by using the “Mid()” function.

(3) Combine result of (1) and (2) by using “Concatenate()” function and inserting 0 after value obtained in (1)

(4) Utilize copy and paste function.

(5) Check the results.

(6) If you are satisfied with the result—combined IDs, copy this entire column and Paste Special/Values to the Custom Data Item column.

(7) Import the Excel in P3. (Don’t forget to delete the temporary/calculated data in Excel)



If you have other problems in Excel, just let me know.



Cheers!

Sen

Gordon,



The parameters "contains", "does not contain", "starts with" and "ends with" would allow you to do matches on subset of text.



Regards,

Bill