Join 34,000+ subscribers and receive articles from our blog about software quality, testing, QA and security.
 

Ellipses from an imported file create ‘garbage’ characters in TestRail


#1

The export doesn’t seem to like ellipses.

The original data as input via TestRail:

How it appears in the EXCEL export file after opened in Excel:

So I did a search and replaced: … with: …


#2

Hi Hebert,

Thanks for your posting. The export actually does support it but the default File | Open behavior in Excel does not always recognize the UTF-8 (Unicode) encoding of CSV files. You can open the files with the correct encoding as follows:

http://stackoverflow.com/questions/6002256/is-it-possible-to-force-excel-recognize-utf-8-csv-files-automatically

(see the first answer)

I hope this helps!

Cheers,
Tobias


#3

Thank you very much. That helps! I appreciate your quick response!


#4

You are welcome, Hebert :slight_smile:

Cheers,
Tobias