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

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

Add yours

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

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

Google+ photo

You are commenting using your Google+ 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 )

Connecting to %s

Create a website or blog at WordPress.com

Up ↑