Get Started with Redwood for Oracle Cloud HCM Begin Now
Identify if comma is present in a field
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:
0