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.


First you go to Tool ->  Global Change


Click on “New” button.


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


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


Click on “Change” button.


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


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.



Author: Khuong Do

Khuong Do is a Project Planner / Construction Claims Consultant / Delay Analyst 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 SGC company, providing Delay Analysis service. They have offices in Beijing – China and Dubai – UAE.

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

Leave a Reply

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

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