2 Replies Latest reply on Aug 21, 2011 4:24 PM by LaRetta_1

    PatternCount function: calculation extracts text quote mark (")

    SonyaRichert

      Title

      PatternCount function: calculation extracts text quote mark (")

      Post

      Is there a calculation, maybe other than "PatternCount" that will extract a quote mark from a text string?

       

      If ( PatternCount ( <field name> ; " " " )  ≥ 1 ; Left ( <field name> ; Position ( <field name> ; " " "; 1 ; 1 ) -1 ) ; <field name> )

       

      Gives "An operator is expected here:

      If ( PatternCount ( <field name> ; " " " )  ≥ 1 ; Left ( <field name> ; Position ( <field name> ; " " "; 1 ; 1 ) -1 ) ; <field name> )

       

      If ( PatternCount ( <field name> ; " " " )  ≥ 1 ; Left ( <field name> ; Position ( <field name> ; " " "; 1 ; 1 ) -1 ) ; <field name> )

       

      Turning off "Smart Quotes" didn't solve it.

       

      Using back slash ignores quote mark.

       

      If ( PatternCount ( <field name> ; " \" " )  ≥ 1 ; Left ( <field name> ; Position ( <field name> ; " \" "; 1 ; 1 ) -1 ) ; <field name> )