Discussions

Expand all | Collapse all

Odd text formatting / substitution on connected table

  • 1.  Odd text formatting / substitution on connected table

    Posted 02-19-2019 19:42
    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




  • 2.  RE: Odd text formatting / substitution on connected table

    Posted 02-19-2019 19:52
    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.



  • 3.  RE: Odd text formatting / substitution on connected table

    Posted 02-19-2019 21:34
    Thanks Mark, that new formula field looks useful (and timely).  


  • 4.  RE: Odd text formatting / substitution on connected table

    Posted 02-19-2019 22:00
    Occasionally in life you get lucky. Enjoy that brief moment on February 24th.