How to Trim Activity ID or Activity Name in Primavera P6

When we think about Trim data, we usually export and do it in excel. However Primavera P6 also give us a tool to trim data by itself.

For example you need to get rid of the “A” letter in Activity ID.

1

First you go to Tool ->  Global Change

2

Click on “New” button.

3

In “Then” section, In Parameter select “Activity ID”, In Parameter/Value select “RightString(Parameter,#)”

4

Then click on that field to adjust “Parameter” value to “Activity ID” and “#” value to “4”.

5

Click on “Change” button.

6

P6 will show you a preview of the change. Click on “Commit Changes” button.

7

Now you can see there is no “A” letter in your Activity ID.

This tool also can be applied to Activity Name and some other text field.

8

Advertisements

Author: doduykhuong

Chief Planning Engineer. Scheduler. Oracle Primavera P6 Certified Specialist. Provide Primavera P6, Microsoft Project Tips & Tricks

2 thoughts on “How to Trim Activity ID or Activity Name in Primavera P6”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s