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 though.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
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
      ------------------------------