You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Finding Records with Trailing Space in OTBI

Received Response
32
Views
4
Comments
in Reporting and Analytics for HCM 4 comments

Summary:

Finding records that have a trailing space in OTBI

Content (required):

We have file transfers that fail when a trailing space is on the end of Address Line 1. I've been able to find the last character at the end of the field, however, none of the filters when applied will call out those records. Instead I get non-problematic records as well.

Trying to see if there is a solution to finding trailing spaces in fields in OTBI

Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!