Getting error Field ‘Test Name’ cannot contain the following characters: \/:%’*?<>|” with Excel Add-in
| ♥ 0 |
When exporting a 200 row spreadsheet from Excel into QC, I receive an error: error "Row 102, Column: B – Field ‘Test Name’ cannot contain the following characters: \\/:%’*?<>|" I also get the error for many other rows It appears to be for random rows and always for the "Test Name" column. Some rows import, some don’t – though I do not see any of these "bad" characters int eh name text in Excel. Any Ideas?
Marked as spam
|
Posted by |
Private answer
Have you looked carefully at the text used for the Test Name in these cells in Excel? A single quote is a ''quoted'' string in Excel indicating you want to use the cell to hold a label or something. Perhaps either someone accidentally ''quoted'' it again, or it got copied verbatim from another cell and got quoted again somehow. You can see them show up in the formula/address line when highlighting the cell from column B for each offending row. Just take them out and try again. If you are on QC11, when you upgrade to 11.52 or later (hopefully real soon), they are doing a better job of trapping these ''illegal'' characters as they get written to QC on import or cut/paste. Marked as spam
 Posted by pt-barnum (Questions: 4, Answers: 509) Answered on August 28, 2014 3:42 pm
|