AnsweredAssumed Answered

PatternCount function: calculation extracts text quote mark (")

Question asked by SonyaRichert on Aug 21, 2011
Latest reply on Aug 21, 2011 by LaRetta_1

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> )

 

Outcomes