Jump to content
  • 0

Pasting In Text Field Generates Odd Characters



We have run across a problem when pasting text into a text box on an entry or edit datapage.  If you paste text that has an apostrophe (or bullet points as well) Caspio turns the punctuation mark into a black diamond with a question mark in the middle.  The next time you pull up the record, all the black diamonds will be replaced with the text string "�".


If you enter an apostrophe from the keyboard directly into the text box, it stays as it should.  I mostly see this behavior when pasting from MS Word.  Although it happens when pasting from a website at times.


I guess I have 2 questions.  First, is it possible to keep formatting in a text field?  Or second, is it possible to paste the information just as text?

Link to comment
Share on other sites

5 answers to this question

Recommended Posts

  • 0

Hi Jan,


Yes, the fields are Text64000.  For the most part they do seem to "remember" things.  It seems to eliminate blank lines on occasion, which may be related to the pasting issue.  If I type an apostrophe it will remain.  However if I paste text containing an apostrophe (or certain other punctuation marks) it's converted into the iterations I explained above.



Link to comment
Share on other sites

  • 0

I never found an "easy" solution to this, but I found a way to work with it.


I added a link to the datapages where the test64000 fields are (made the hyperlink to target _blank so that a new page would open and therefore not interrupt the data entry).  The link opens this page:




The person in our organization who does that particular data entry is VERY happy with the converter!  She used to go back and manually fix all the diamond-question-marks and now she doesn't have to do that anymore. BTW, I got the code from the web from someone who said, "Feel free to copy the code," so . . .  feel free to copy the code.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...