Formatting Question

[MichelleDuncan2]

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. 

[Jim-Moore]

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