+ Start a Discussion

Trouble using Merge Field with a Function

{!SUBSTITUTE("This is a test","a","/") }
evaluates to "This is / test", as expected.
But {!SUBSTITUTE("{!Opportunity.Name}","a","/") }
evaluates *literally* to "{!Opportunity.N/me}", instead of embedding slashes in the actual Opportunity Name.
Am I doing something wrong or is this broken. I can't find any documentation that addresses this.
I guess you could try:

{!SUBSTITUTE({!Opportunity.Name},"a","/") }

or this:

{!SUBSTITUTE(Opportunity.Name,"a","/") }

Just a guess.

Doug ChasmanDoug Chasman
{!SUBSTITUTE(Opportunity.Name,"a","/") } is what you want - no guessing about it.

The {! } delimiters are just like <%= %> in other templating technologies like JSP and ASP.NET and demark the start and end of formula expressions (one of the simplest being just a field reference - the only thing available prior to Winter '07). Once inside {! } you no longer need or want additional {! }'s.

Thanks guys--that was perfect! Don't use JSP or ASP.NET, so had no clue. I guess you just have to know. Now I do.