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: Khuong Do

Khuong Do is a Project Planner in Civil, Transportation and Oil & Gas Industry. He has worked as a Primavera Consultant Specialist since 2006 . He holds a Civil Engineering degree and a Bachelor of Information Management System. Now he is working in Petronas RAPID project, one of the biggest Refinery and Petrochemical complex, in Pengerang – Malaysia.

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