[SalesForce] How to escape a double quotation mark in VisualForce context

I am trying to process a string before displaying it in a visualforce page. What I need to do is remove any quotation marks in the text field before I use it to assemble a link path. The following code works – it removes any 'S' characters from the string. However when I substitute in a '"' which is what I want to remove, it is interpreted as ending the value argument and the page won't save. I thought I could escape it out with '\"' or '\\"' and I also tried '&quot' but none of those options worked.

        <td class="value">
            <apex:outputText value="{!SUBSTITUTE(Work_Order__c.Drawing_Path__c, 'S', '')}" />
        </td>

I know that I could do my processing at another step (either with a formula field or an apex trigger) but I was really hoping to do it here as I have other areas built around the string still having the quotes in it. Is there any way to solve this problem in the VisualForce page only?

Best Answer

This works in my developer org:

<apex:page standardController="Account">
    <apex:form>
        <apex:inputField value="{!Account.Name}" />
        <apex:outputText value="{!SUBSTITUTE(Account.Name,'\"','')}" />
    </apex:form>
</apex:page>

Apparently, syntax highlighting can't seem to figure it out, but it should compile just fine (press Enter in the demo page to see the resulting output).

Related Solutions

[SalesForce] How to escape a double quote in a Visualforce attribute

This can be done using the itemEscaped="false" attribute on the apex:selectOption tag. This will allow you to use HTML in the label text and render it into the page.

In your case, you want to use " to produce the quote character in the label: User and 2 "Reports To" Levels.

<apex:selectList id="myElement" value="{!selectedValue}" size="1">
    <apex:selectOption itemEscaped="false" itemValue="2" 
        itemLabel="User and 2 &quot;Reports To&quot; Levels"/>
</apex:selectList>

[SalesForce] How to set defaults when creating a record from a visualforce page button/link

Found a nice blog that explains the URLFOR Method:

{!URLFOR(target, id, [inputs], [no override])}

Parameters shown in brackets ([]) are optional.

target: You can replace target with a URL or action, s-control or static resource.
id: This is id of the object or resource name (string type) in support of the provided target.
inputs: Any additional URL parameters you need to pass you can use this parameter. you will to put the URL parameters in brackets and separate them with commas ex: [param1="value1", param2="value2"]
no override: A Boolean value which defaults to false, it applies to targets for standard Salesforce pages. Replace "no override" with "true" when you want to display a standard Salesforce page regardless of whether you have defined an override for it elsewhere.

Basically, you just call the existing new holiday button and set the parameters in the URLFOR like this...

<apex:commandButton action="{!URLFOR($Action.Holiday__c.New,null
,['CF00N00000008igMg'=SiteProgram__c.Name,'CF00N00000008igMg_lkid'=SiteProgram__c.Id, 'retURL'=SiteProgram__c.Id])}" value="Create New Holiday" id="theButton"/>

Best Answer

Related Solutions

[SalesForce] How to escape a double quote in a Visualforce attribute

[SalesForce] How to set defaults when creating a record from a visualforce page button/link

Related Topic