Odd text formatting / substitution on connected table

  • 0
  • 1
  • Question
  • Updated 4 months ago
  • Answered
I have a connected table in Quick Base that is pulling tickets from Zendesk.  One of the Zendesk fields is a long text field (description).   When records are pulled into Quick Base,  apostrophes are replaced with the string:  â€TM  For example, the word "don't" looks like "donâ€TMt"  

Is there a way to deal with this (aside from not using contractions)?  Any idea what causes this?  I've seen similar with some CSVs.  

Iâ€TMd appreciate any input since text issues arenâ€TMt fun.  

Thx.

Rick


Photo of Rick Lindner

Rick Lindner

  • 172 Points 100 badge 2x thumb

Posted 4 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,572 Points 50k badge 2x thumb
i would sit tight until the February 24th release and then take advantage of the new functions we will get on that date.  See the previous thread in this forum and Harrison's response.

https://community.quickbase.com/quickbase/topics/custom-deliminator-for-multiselect-text-field

ie the idea is you get what you get on the data feed, but rename that field to be [description (raw import)] and then have a new formula field called [Description], with that new SearchandReplace() function.

Photo of Rick Lindner

Rick Lindner

  • 172 Points 100 badge 2x thumb
Thanks Mark, that new formula field looks useful (and timely).  
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,328 Points 50k badge 2x thumb
Occasionally in life you get lucky. Enjoy that brief moment on February 24th.