Weird characters on an Outlook Exchange Sync connection

  • 0
  • 2
  • Question
  • Updated 5 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

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb

Posted 7 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?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
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,044 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?