'User Administration' Excel Data Extract Contain Trailing Characters (Doc ID 2246143.1)

Last updated on MARCH 12, 2021

Applies to:

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:

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:
    =UNICODE(RIGHT(A2;1))
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.

EXPECTED OUTCOME:
Values exported to be clean of any trailing characters.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.