Skip to main content
Question

Weird characters on an Outlook Exchange Sync connection

  • September 26, 2018
  • 0 replies
  • 62 views
I have a Sync table coming in from Outlook.  The body field has many weird characters in it.  I'm not sure if this forum will accept them, but many emails have a an 

? 

character in place of a carriage return  and there are other weird characters too.  Any ideas on why or how fix that?

? 

    • ChrisChris
    • Quickbase Alumni
    • September 26, 2018
    Are they possibly formatting characters? Can you pass the content of the body to some ascii only sieve that will remove the formatting first?
    • QuickBaseCoachD
    • Author
    • Quickbase Alumni
    • September 26, 2018
    I suspect that there is no easy answer here.  The main extra characters seem to be that one character, and I suppose I could parse out the text based on that separator in a PART formula and list together Part 1, Part 2 etc and use a "\n" separator to format and retain the carriage return.
    • anomDiebolt
    • Quickbase Alumni
    • September 26, 2018
    Just write a gigantic native formula that substitutes all offending characters in the Unicode space with an empty string.


    I'm having the same issue.  Was a simple resolution found?
    Terms & ConditionsAccessibility statement