[Caitlin Ireland]

Hello,

I am trying to edit a formula for a new attribute, but the string that I need to check if my attribute is “equal” to contains an apostrophe. I put for example: `Education’=”Bachelor’s” and it will not pick up any entries that contain that phrase, even though that is exactly how my Education attribute is coded. Is there something else I need to do? I tried putting a backslash which works in other languages, but I cannot get CODAP to return anything related to any of my attribute entries with apostrophes. Thanks!

Attachments:

1. 

   codap-help.png
   

2. 

   codap-help-2.png
   

[Bill Finzer]

Hi Caitlin,

I tried this out myself and it worked as one would hope. (See enclosed screen capture.)

Could you perhaps give us a share-link to a document in which you experience the problem?

Bill

Attachments:

1. 

   Screenshot-2025-05-12-at-10.18.55 AM.png
   

[Dan Damelin]

It could be that the apostrophe in Caitlin’s doc, the apostrophe in the data set itself, is not an apostrophe, but rather a curly single quote mark.

Attachments:

1. 

   Apostrophes_and_Quotation_Marks_-_Kadence_WP.png
   

[Caitlin Ireland]

Dan,

I think that is the issue. Is there a way to write the other mark on my keyboard, or a way to transform all the entries to a regular apostrophe?

[Dan Damelin]

Try copying the text in the cell, then write the formula and paste in the text from the clipboard rather than writing it out yourself.

You can also probably export the data as CSV and do a find and replace on that kind of an apostrophe (using the clipboard again to copy the apostrophe before engaging the find/replace) either in a spreadsheet program or even a simple text editor. Then reimport the csv into CODAP.

[Caitlin Ireland]

Thanks copying and pasting worked!

[Author]

Posts