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
Get Started with Redwood for Oracle Cloud HCM   Begin Now

Identify if comma is present in a field

edited Aug 20, 2020 2:41PM in Reporting and Analytics for HCM 2 comments

Summary

How to do that in OTBI?

Content

Hi,

we need to embed the following logic into OTBI report

   (CASE 
      WHEN hr_loc.location_name like '%,%' then '"'||hr_loc.location_name||'"' 
      ELSE hr_loc.location_name 
END) g2_location_name,
 
Any ideas?
 
Thanks 
Nicola
 

 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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