Discussions

Expand all | Collapse all

Outlook Connected Sync table has a lot of weird characters

  • 1.  Outlook Connected Sync table has a lot of weird characters

    Posted 24 days ago
    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
    ------------------------------


  • 2.  RE: Outlook Connected Sync table has a lot of weird characters

    Posted 24 days 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
    ------------------------------



  • 3.  RE: Outlook Connected Sync table has a lot of weird characters

    Posted 24 days ago
    Edited by Mark Shnier (YQC) 24 days 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
    ------------------------------