Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Replace underscore in report in view

797926Oct 14 2010 — edited Oct 14 2010
Hi,

I have some data saved in my database in the following format, firstname_lastname so the names are seperated by an underscore. When I view my interactive report, it also shows the name like firstname_lastname, which is okay. But when I use the interactive report search function, I can't search the name like firstname lastname (so with a space) I have to do two searches, one for the firstname and one for the lastname.

Is there a way to;

- edit the search function so I can search firstname lastname and don't have to do this in two searches
- or replace the underscores in the page view with a space?

Regards
This post has been answered by jariola on Oct 14 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 11 2010
Added on Oct 14 2010
2 comments
1,727 views