CRM On Demand - Administration (MOSC)

MOSC Banner

Syntax for picklist item with apostrophe

edited Apr 30, 2014 4:50PM in CRM On Demand - Administration (MOSC) 6 commentsAnswered ✓

I am writing a CASE statement in a report formula and am having issues with it taking the apostrophe that is in the picklist field name.  I get a syntax error when I leave the apostrophe in it, but when I take it out, the formula does not work correctly because the picklist name isn't exact.  I also tried replacing the apostrophe with the ASCII character which validated in the formula, but did not work in the output. The formula works fine if I test it using a picklist name with no apostrophe in it.  Does anyone have any advice?

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