Forum Discussion

AnneMartin's avatar
AnneMartin
Qrew Trainee
3 years ago

Connected Table pulling strange characters

Does anyone know if there is a fix for this, or should I recreate my connected table?

I have a master app containing our customer information. I pull information from this into other apps via connected tables.
The connected table in one of my apps has added extra characters into the middle of the name field for some customers. My other apps are all OK.
The P2P on the end is supposed to be there.

Should read: FAIR FAMILY FARMS         P2P
Reads: 
FAIR FAMILY FARMS LLC                  P2P

This customer is ok:
WES SOLLENBERGER       P2P


------------------------------
Anne Martin
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    If all else fails, you can use SearchAndReplace to make a new formula field and strip out he funny character or replace them with spaces.

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • AnneMartin's avatar
      AnneMartin
      Qrew Trainee
      3 years ago
      Thanks, I was able to do a formula field and remove the funny characters.

      ------------------------------
      Anne Martin
      ------------------------------
  • OanaWhalen's avatar
    OanaWhalen
    Qrew Cadet
    3 years ago
    Did you happen to enter the information on an iPhone/iPad? We've had a lot of issues with importing text entered on iOS apps into QB, as most special characters (including some spaces, tabs, even some normal letters occasionally, etc.) are encoded differently on iOS. Our typical solution has been a long string of SearchAndReplace functions to swap out the odd characters (must copy paste, not retype them) for the intended ones.

    There is also an option under App Properties to toggle UTF-8 encoding, we've had some limited success with changing this setting in the past, but I vaguely recall it causing other issues for us as well.

    ------------------------------
    Oana Toma
    ------------------------------
    • ChaseMoss's avatar
      ChaseMoss
      Qrew Member
      2 years ago

      I know this is a bit older but I wanted to chime in as well. I think Oana is right - we had issues with odd characters showing up in our data when we exported a report as a csv file. The " symbol was showing up as â€. After further investigation, we had to replace " style quotes (quote marks that are slanted) with " quotes (straight line quotes). Once the replacement was made everything exported fine. I think the cause was that the records were originally created on an iPad and it resulted in some kind of encoding problem that only showed up when exporting.



      ------------------------------
      Chase Moss
      ------------------------------