Weird characters on an Outlook Exchange Sync connection

Question

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 · Answer

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 · Answer

I suspect that there is no easy answer here.&nbsp; 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 "
" separator to format and retain the carriage return.

_anomdiebolt_ · Answer

Just write a gigantic native formula that substitutes all offending characters in the Unicode space with an empty string.

macallzimmerman · Answer

I'm having the same issue.&nbsp; Was a simple resolution found?

tamaraerickson3 · Answer

I got around this by creating a formula text field with the search &amp; replace function:SearchAndReplace([Body],"�","")

Forum Discussion

Weird characters on an Outlook Exchange Sync connection