Issue: Handling Backslash Characters

If you have a TSV or CSV file that contains backslashes in any text field, the upload will ignore the backslash and either substitute it for another value or ignore it completely.

For example:

Test\123
Test\1ABC
Test/Testing\123

This behavior occurs because the server treats backslashes as escape characters, for example, \n will insert a new line, \t will insert a tab, and so forth. Note that behavior does not appear when importing Excel files. Excel imports are handled slightly differently, and text data within the cell is processed such that text is in quotes.

Solution: Wrap Text Values with Quotation Marks

To import text fields that contain backslashes, wrap the values in quotes, for example:

"Test\123"
"Test\1ABC"
"Test/Testing\123"

Note that exporting an existing LabKey grid as a TSV or CSV file will not generate double-quotes around the values. To wrap values, either manually edit individual cells, or configure the save settings in a spreadsheet editor.

Discussion

Was this content helpful?

Log in or register an account to provide feedback


previousnext
 
expand all collapse all