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 conne...
Forum Discussion
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
------------------------------
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
------------------------------
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
------------------------------