You need to sign in to do that
Don't have an account?
PDXMarinerFan
Need to Report On and/or Verify for double quotation marks
Below is an example of data in a text field. We need a way to determine if the text starts and ends with a quotation mark. I have tried to start a formula field, but that I can not test for quotation marks. Does anyone know how this can be done.
"J:\\US Mailing Program\\Electronic Signature Image Files\\Barry H. Jaruzelski.jpg"
Each character must follow a backslash.
For example, if your formula field is set to output (Apples\Bananas), it must be listed in the formula as (Apples\\Bananas) in order for the formula to work correctly.
Similarly, if your formula field is set to output (This is a "test" value), it must be listed in the formula as (This is a \"test\" value).
This applies only to text formula fields as this is the only data type where / and "" can appear in the output value.
IF(BEGINS( Primary_Owner_Signature__c ,"\""),"TRUE", "FALSE")
Mark Bruso
Portland, Oregon