Can anyone tell me how to format the excel spreadsheet in Survey123 so I don't get double quotes for what should be an inch symbol? I'm pulling data from the info.csv table to populate fields. See example attached.
Hi Michelle
When working on a CSV in Excel, it can enclose text strings in double quotes " " (particularly if the string contains spaces). The quote mark used in the string (used for inches) could be confusing things. Try opening the CSV in a text editor to see if it shows something like "CROSS PLATE ANCHOR 24""". A simple fix would be to find/replace all the triple quotes with double quotes in the text editor.
Hope this helps
Best,
Jim
Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
