'User Administration' Excel Data Extract Contain Trailing Characters
(Doc ID 2246143.1)
Last updated on JUNE 30, 2021
Applies to:
Primavera P6 Enterprise Project Portfolio Management - Version 16.2.4.0 and laterPrimavera P6 Enterprise Project Portfolio Management Cloud Service - Version 16.2.4.0 and later
Information in this document applies to any platform.
Symptoms
DESCRIPTION OF PROBLEM:
Download from Users page will add an extra character to each cell exported, making functions like Trim to not work correctly.
STEPS TO REPRODUCE:
- Log into P6 Web.
- Navigate to Administer>User Administration.
- Select the Users page.
- Use the download link to download the list of users.
- Open the downloaded file in Excel file.
- Click on any cell to edit the value.
- Notice that there is an extra character at the end of the value that looks like space/blank.
- Use the Trim function =Trim(A2).
- Copy the result of the trim function.
- Paste it to another cell using the Paste Values option.
- Notice that the extra character still exists at the end of the cell.
- Use the Unicode function to determine what character is extra:
=UNICODE(RIGHT(A2;1)) - Notice the extra character is 160.
- Use the Substitute function to ensure the Trim function works:
=TRIM(SUBSTITUTE(A2;CHAR(160);"")) - this workaround should work.
EXPECTED OUTCOME:
Values exported to be clean of any trailing characters.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |