Formatting Question

180
1
01-15-2020 10:53 AM
MichelleDuncan2
New Contributor III

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. 

Tags (1)
0 Kudos
1 Reply
Jim-Moore
Esri Regular Contributor

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