Escape Excel: A tool for preventing gene symbol and accession conversion errors.
Escape Excel: A tool for preventing gene symbol and accession conversion errors.
复制标题
DOI：
10.1371/journal.pone.0185207
复制
发表时间：
2017
期刊：
影响因子：
3.7
通讯作者：
Eschrich JA
中科院分区：
文献类型：
--
作者：
Welsh EA;Stewart PA;Kuenzi BM;Eschrich JA
Microsoft Excel自动将某些基因符号、数据库登录和其他字母数字文本转换为日期、科学计数法和其他数字表示。这些转换会导致导入文本随后发生不可逆的损坏。最近一项对流行基因组文献的调查估计，五分之一的补充基因列表的论文都存在这个问题。在这里，我们介绍了一个开源工具Escape Excel，它通过生成一个可以安全导入Excel的转义文本文件来防止这些错误的转换。Escape Excel以多种格式（http：//www.github.com/pstew/escape_excel）实现，包括基于Perl脚本的命令行、仅限Windows的Excel加载项、OS X拖放应用程序、简单的Web服务器以及Galaxy Web环境界面。测试服务器实现可作为Galaxy接口（http：//www.example.com）和简单的非Galaxy Web服务器（http：//apostl.moffitt.org：8000/）访问。apostl.moffitt.org Escape Excel可检测并转义各种有问题的文本字符串，以便在导入Excel时不会错误地将其转换为其他表示形式。有问题的字符串包括类似日期的字符串、类似时间的字符串、数字前面的前导零以及不应自动转换为科学计数法的长数字和字母数字标识符。人们希望，提高对这些潜在数据损坏问题的认识，以及在导入Excel之前对文本文件进行谨慎的转义，将有助于减少科学分析和出版物中Excel损坏的数据量。
Microsoft Excel automatically converts certain gene symbols, database accessions, and other alphanumeric text into dates, scientific notation, and other numerical representations. These conversions lead to subsequent, irreversible, corruption of the imported text. A recent survey of popular genomic literature estimates that one-fifth of all papers with supplementary gene lists suffer from this issue. Here, we present an open-source tool, Escape Excel, which prevents these erroneous conversions by generating an escaped text file that can be safely imported into Excel. Escape Excel is implemented in a variety of formats (http://www.github.com/pstew/escape_excel), including a command line based Perl script, a Windows-only Excel Add-In, an OS X drag-and-drop application, a simple web-server, and as a Galaxy web environment interface. Test server implementations are accessible as a Galaxy interface (http://apostl.moffitt.org) and simple non-Galaxy web server (http://apostl.moffitt.org:8000/). Escape Excel detects and escapes a wide variety of problematic text strings so that they are not erroneously converted into other representations upon importation into Excel. Examples of problematic strings include date-like strings, time-like strings, leading zeroes in front of numbers, and long numeric and alphanumeric identifiers that should not be automatically converted into scientific notation. It is hoped that greater awareness of these potential data corruption issues, together with diligent escaping of text files prior to importation into Excel, will help to reduce the amount of Excel-corrupted data in scientific analyses and publications.
影响因子：
12.3
作者：
Ziemann M;Eren Y;El-Osta A
通讯作者：
El-Osta A
影响因子：
14.9
作者：
Barrett T;Wilhite SE;Ledoux P;Evangelista C;Kim IF;Tomashevsky M;Marshall KA;Phillippy KH;Sherman PM;Holko M;Yefanov A;Lee H;Zhang N;Robertson CL;Serova N;Davis S;Soboleva A
通讯作者：
Soboleva A
影响因子：
3
作者：
Zeeberg, BR;Riss, J;Weinstein, JN
通讯作者：
Weinstein, JN