Thank you, NetWallah. Not sure how to upload my csv file, (it has many rows) but I pasted a few rows below. 

sid    name    genotype    gender    tGroup    DNABl    DNATw2    DNAT
+w4    DNATw8    DNATw12    DNATw16    DNATw24    DNATw48    DNATw8-Bl
+    eAgAbScr    eAgABBl    eAgAbTw12    eAgAbTw24    eAgAbTw48    ALT
+Scr    ALTBl    ALTTw2    ALTTw4    ALTTw8    ALTTw12    ALTTw16    A
+LTTw24    ALTTw48    coreTcellBl    coreTcellTw4    coreTcellTw8    c
+oreTcellTw12    coreTcellTw16    coreTcellTw24    coreTcellTw48    su
+rfaceTcellBl    surfaceTcellTw4    surfaceTcellTw8    surfaceTcellTw1
+2    surfaceTcellTw16    surfaceTcellTw24    surfaceTcellTw48    HLA_
+A_1    HLA_A_2    HLA_B_1    HLA_B_2    HLA_DRB1_1    HLA_DRB1_2    H
+LA_DRB3_1    HLA_DRB3_2    HLA_DRB4_1    HLA_DRB4_2    HLA_DRB5_1    
+HLA_DRB5_2    HLA_X_1    HLA_X_2
1    AUC-001    C    Female    3    7.8    3.85    3.47    2.83    2.1
+8    2.69    2.18    2.176    -4.97    + / -    + / -    + / -    + /
+ -    + / -    617    69    47    35    28    34    24    25    22   
+ 55    xx    130    36.66666667    5    23.33333333    0    50    xx 
+   201.6666667    0    0    0    0    *0201/0207/0209/0215N/0218/0220
+/0224/0229/0230/0231/0233/0234/0242/0243N     *0301/04     *0702/05/0
+6/07/21/22/23/26/30/33    *4001/14/22N/23/33/42/43/45    *1101/04/12/
+15/24/27/28/29/32/33/35/37/38/39/43    *1501/02/04/05/06/07/08/09/11/
+13    *0201/02/03/06/10/11/12/14/15/17/18                *0101/05/09/
+11/12/13            
2    AUC-002    B    Male    3    11.13    10.51    7.69    5.95    6.
+74    5.66    5.38    5.152    -5.18    + / -    + / -    + / -    + 
+/ -    + / -    82    61    72    55    73    66    95    87    70   
+ 31.66666667    65    xx    3.333333333    5    0    65    78.3333333
+3    56.66666667    xx    0    0    0    25    *0201/0204/0207/0209/0
+215N/0217/0218/0220/0224/0229/0230/0231/0232N/0233/0239/0242/0243N   
+  *0203     *4601/02     *4001/4010/4022N     *1401/26/32/38/39     *
+1405                                 
3    AUC-003    C    Male    3    9.03    7.7    7.51    5.67    4.74 
+   4.3    3.34    2.176    -3.36    + / -    + / -    + / -    + / - 
+   + / -    87    102    83    102    107    89    57    47    26    
+33.33333333    46.66666667    18.33333333    15    75    15    0    3
+3.33333333    40    30    0    0    0    5    *3101/02/05     *2402/2
+403/2409N/2411N/2415/2420/2421/2425/2426/2427     *1538     *4002/29 
+    *0801/03/14/16     *1101/12/15/19/24/27/28/29/39                 
+                
4    AUC-004    B    Male    1    7.23    3.43    2.66    2.18    2.18
+    2.18    2.18    2.176    -5.05    - / +    - / +    - / +    - / 
++    - / +    71    335    241    200    66    51    46    31    28  
+  107    157    18    xx    168    45    10    120    168    37    xx
+    0    0    0    *1101/02/03/05     *1101/02/03     *5502/07     *1
+518     *0801/03/14/16     *1201/02/06

[download]

In reply to Re^2: dbi::CSV works with text, but not numbers by Sandy_Bio_Perl
in thread dbi::CSV works with text, but not numbers by Sandy_Bio_Perl

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.