CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

CASE formula for switching text within a field

edited Aug 16, 2011 4:54AM in CRM On Demand - Reports and Dashboards (MOSC) 16 commentsAnswered ✓
I'm trying to put a CASE filter on a field and keep getting errors.

My goal: When the text in the field contains a comma, change it to a semi-colon.

I believe I'm getting hung up on what verbiage to use (contains?) in the case statement.  Ultimately, I need to export csv data from a report and whenever a comma is in the field, it errors out.

Here's what I have currently: CASE Campaign."Campaign Name" WHEN ',' THEN ';' ELSE Campaign."Campaign Name" END

Regards

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center