[ensembl-dev] Exons numbers in VEP

[Eva Goncalves Serra]

Thanks Matthew - I don¹t normally read in these files in Excel so wasn¹t
aware. Thanks a lot!

Eva

On 28/10/2014 11:02, "Healy, Matthew" <Matthew.Healy at bms.com> wrote:

>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.
>
>_______________________________________________
>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/