Forum Discussion

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago

Outlook Connected Sync table has a lot of weird characters

Has anyone found a way to present Outlook Sync Connected table data in a way that does not gave so much weird characters?  My Sync table is readable, I guess, but a lot of strange characters come thou...
Quickbase Sync
RickPutnam's avatar
RickPutnam
Qrew Cadet
5 years ago
Hi, Mark,

By weird characters do you mean all the html in the message body? If so, you may be able to use a regular expression to strip them out. I'm not familiar with Outlook Sync so I'm not sure whether you can apply a regular expression during load. In Pipelines, it is possible to apply a regex as a step in the import process. Pipelines (or Jinja) also has a built-in mechanism to strip HTML. https://help.quickbase.com/pipelines/transforming_data.html#Transforming_text

If you have a minute, what is Outlook Sync?

------------------------------
Rick Putnam
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
Yes I ended up using a native Quick Base formula to strip out the weird characters.  I did this quickly last night for a client demo and when we go live, I will just keep adding to the formula as I see the characters come up in email.

OutLook Sync means that I set up a Connected "Sync" table where the source was my Outlook 365  In Box.

var text StepOne = SearchAndReplace([Body],"Ā","");
var text StepTwo = SearchAndReplace($StepOne, "€","");
var text StepThree = SearchAndReplace($StepTwo,"™","");
var text StepFour = SearchAndReplace($StepThree, "¿","");
var text StepFive = SearchAndReplace($StepFour, "»","");
var text StepSix = SearchAndReplace($StepFive, "ļ","");
var text StepSeven = SearchAndReplace($StepSix, "â","");

$StepSeven
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------