Weird characters on an Outlook Exchange Sync connection

  • 0
  • 2
  • Question
  • Updated 8 months ago
  • In Progress
  • (Edited)
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?

 
Photo of QuickBaseCoach App Dev./Training (Mark Shnier)

Posted 10 months ago

  • 0
  • 2
Photo of Chris

Chris

  • 4,430 Points 4k badge 2x thumb
Are they possibly formatting characters? Can you pass the content of the body to some ascii only sieve that will remove the formatting first?
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.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,224 Points 20k badge 2x thumb
Just write a gigantic native formula that substitutes all offending characters in the Unicode space with an empty string.


Photo of Macall Zimmerman

Macall Zimmerman

  • 60 Points
I'm having the same issue.  Was a simple resolution found?