Skip to content
ProjectControls.com
Oracle Primavera - PM6

How to remove symbols (*, A) from Dates

In the Open Standard
Nicolò SpagnaMember for 11 years 10 months
Created
4
2
0

Hello everyone,

when I creat a report in order to extract the Finish Dates of the Activity IDs and put them in an excel database, activities that are in progress or performed, will be extract in this way:

 PRC-3000/010Completed01-09-14 A15-09-14 A

Activities with constraints, will instead appear in this way:

 PRC-3010/030Not Started10/11/201411-06-15*

 

Is that possible to remove these letters/codes in order to have always the same layout of the data?

This is how I would like they all appear:

 PRC-3000/030Not Started19/11/201407/07/2015
 PRC-3000/040Not Started08/07/201529/08/2015

 

Thanks in advance!

 

Ciao

Nicolò

Save Follow Follow forum Report
Reply New topic

4 replies

Oldest first
  1. 0
    Paul Harris ·
    #1

    If you post the report to

    If you post the report to Excel you can remove the "*" and "A" by using find and replace.

    To remove the "*" you must use the find option of "~*" and thne Excel will specifically look just for the "*". If you do not use this option the all data will be removed. Leave the Replace with field blank.

    Regards

    Paul E Harris
    BSc Hons, Certified Cost Engineer, PRINCE2 Practitioner
    Managing Director and President
    Eastwood Harris Pty Ltd, Australia
    http://www.eh.com.au,  http://www.primavera.com.auand http://eastwoodharris.com.
    Project Control Consultants and Planning and scheduling software book and training material publishers
    Primavera P6 Version 8.3 eLearning available from http://www.primaskills.com.au/project-management-training/

     

    Report
  2. 0
    Nicolò Spagna ·
    #2

    Thanks Paul, for the moment

    Thanks Paul,

     

    for the moment this is very usefull. I didn't know about the ~

    But i wanted to know if it was possible to avoid this process, just using some setting in Primavera.

     

    Thanks

    Nicolò

    Report
  3. 0
    Paul Harris ·
    #3

    NicolòI do not think your

    Nicolò

    I do not think your can,but you could try User Defined Fields and Global Change to put the dates into the field or try displayinm other date fields such as Actual and Remaing Dates, but displaying these get problematinc as they either display blanks or the wrong dates. For Example the Early and Late Dates do not display Actual Dates correctly.

    Regards

    Paul E Harris
    BSc Hons, Certified Cost Engineer, PRINCE2 Practitioner
    Managing Director and President
    Eastwood Harris Pty Ltd, Australia
    http://www.eh.com.au,  http://www.primavera.com.auand http://eastwoodharris.com.
    Project Control Consultants and Planning and scheduling software book and training material publishers
    Primavera P6 Version 8.3 eLearning available from http://www.primaskills.com.au/project-management-training/

    Report
  4. 0
    Zoltan Palffy ·
    #4

    yes Paul has the correct

    yes Paul has the correct solution use find and replace in excel 

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?