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

5 Replies

Related Content

Filter records based on table connection

Exchange Templates Removed?

Connected table not updating when record is changed in the connected database

Connected Table Error

Pipelines - Connected Table Refresh

Recent Discussions

Many to Many too Many...

Selecting which fields to display from Formula URL searches

Bulk create child records from selection list

(Pipelines) Get Users in Role / Process XML from HTTP API

Help Needed with Quickbase Pipeline to Accumulate Values Instead of Overwriting