[ensembl-dev] Exons numbers in VEP

[Healy, Matthew]

When importing text into Excel, unless one specifies that a column is Text format it will use the General format.  General tries to parse calendar dates, which become integers -- count of days since 1Jan 1900 (assuming 1900 was a leap year, which it was not in the Gregorian Calendar, for compatibility with Lotus 1-3-3 format) or on the Mac since 1904.

So certain fractions that could be dates get munged.  Also certain HGNC Gene Symbols like SEPT3 or MARCH1 get munged, so if you're munging Exon Numbers you should also check gene symbols!

________________________________________
From: dev-bounces at ensembl.org [dev-bounces at ensembl.org] On Behalf Of LAW Andy [andy.law at roslin.ed.ac.uk]
Sent: Tuesday, October 28, 2014 6:42 AM
To: Ensembl developers list
Subject: Re: [ensembl-dev] Exons numbers in VEP

Has the output file been through Excel at all?

On 28 Oct 2014, at 10:17, Eva Goncalves Serra <egs at sanger.ac.uk> wrote:

> Hi,
>
> After running VEP I realised that some variations do have numbers like ‘46569’ in the Exons number field, rather than for example ’18/20’. Does anyone know why this is?
>
> Thanks very much,
>
> Eva
> _______________________________________________
> Dev mailing list    Dev at ensembl.org
> Posting guidelines and subscribe/unsubscribe info: http://lists.ensembl.org/mailman/listinfo/dev
> Ensembl Blog: http://www.ensembl.info/


--
The University of Edinburgh is a charitable body, registered in
Scotland, with registration number SC005336.


_______________________________________________
Dev mailing list    Dev at ensembl.org
Posting guidelines and subscribe/unsubscribe info: http://lists.ensembl.org/mailman/listinfo/dev
Ensembl Blog: http://www.ensembl.info/

This message (including any attachments) may contain confidential, proprietary, privileged and/or private information.  The information is intended to be for the use of the individual or entity designated above.  If you are not the intended recipient of this message, please notify the sender immediately, and delete the message and any attachments.  Any disclosure, reproduction, distribution or other use of this message or any attachments by an individual or entity other than the intended recipient is prohibited.