'User Administration' Excel Data Extract Contain Trailing Characters

(Doc ID 2246143.1)

Last updated on MAY 02, 2017

Applies to:

Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version and later
Primavera P6 Enterprise Project Portfolio Management - Version and later
Information in this document applies to any platform.


Download from Users page will add an extra character to each cell exported, making functions like Trim to not work correctly.


  1. Log into P6 Web.
  2. Navigate to Administer>User Administration.
  3. Select the Users page.
  4. Use the download link to download the list of users.
  5. Open the downloaded file in Excel file.
  6. Click on any cell to edit the value.
  7. Notice that there is an extra character at the end of the value that looks like space/blank.
  8. Use the Trim function =Trim(A2).
  9. Copy the result of the trim function.
  10. Paste it to another cell using the Paste Values option.
  11. Notice that the extra character still exists at the end of the cell.
  12. Use the Unicode function to determine what character is extra:
  13. Notice the extra character is 160.
  14. Use the Substitute function to ensure the Trim function works:
    =TRIM(SUBSTITUTE(A2;CHAR(160);"")) - this workaround should work.

Values exported to be clean of any trailing characters.




Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms