Loading ...
Sorry, an error occurred while loading the content.
 

Res: [PBML] How can I remove the quotes from within this array or cvs file?

Expand Messages
  • tnas
    One suggest is add the follow statment as first command in loop : $data =~ s/ //g; HTH. perl -e $_= tMM naaCt
    Message 1 of 1 , Mar 5, 2007
      One suggest is add the follow statment as first command in loop :
      <code> $data =~ s/"//g; </code>

      HTH.

      perl -e '$_="tMM naaCt Feocmama_itpUilucoGa";$_.=$1,print $2 while s/(..)(.)//;print substr$_,1,1;'
      "...just because I don't know the meaning of my art, does not mean it has no meaning..." S.D.

      ----- Mensagem original ----
      De: chipwillis2003 <chipwillis2003@...>
      Para: perl-beginner@yahoogroups.com
      Enviadas: Sexta-feira, 2 de Março de 2007 16:12:05
      Assunto: [PBML] How can I remove the quotes from within this array or cvs file?













      How can I remove the quotes from within this array?

      Or would I read the entire file first and remove the quotes from it

      first?

      Can I get an example of the best solution?

      Here is my code:



      # open the comma delimated file

      open (TXTFILE, "c:/SOARimports/ NU_AD2032_ ILINC_EXTRACT_ stf.csv") or

      die("Unable to open file");

      @lines = <TXTFILE>;



      # read file into an array

      foreach $data(@lines) {

      #loop through file putting users in array here

      # split the line of text by comma

      my @values = split(',', $data);



      # put the line into an array

      my($InstructorID, $InstFname, $InstLname, $InstEmail) = @values;



      Here is an example of the cvs file:

      "100043093", "Long,Paul" ,longps@hotmail. com



      I need to remove the quotes.

      Thank you,

      Chip














      <!--

      #ygrp-mlmsg {font-size:13px;font-family:arial,helvetica,clean,sans-serif;}
      #ygrp-mlmsg table {font-size:inherit;font:100%;}
      #ygrp-mlmsg select, input, textarea {font:99% arial,helvetica,clean,sans-serif;}
      #ygrp-mlmsg pre, code {font:115% monospace;}
      #ygrp-mlmsg * {line-height:1.22em;}
      #ygrp-text{
      font-family:Georgia;
      }
      #ygrp-text p{
      margin:0 0 1em 0;
      }
      #ygrp-tpmsgs{
      font-family:Arial;
      clear:both;
      }
      #ygrp-vitnav{
      padding-top:10px;
      font-family:Verdana;
      font-size:77%;
      margin:0;
      }
      #ygrp-vitnav a{
      padding:0 1px;
      }
      #ygrp-actbar{
      clear:both;
      margin:25px 0;
      white-space:nowrap;
      color:#666;
      text-align:right;
      }
      #ygrp-actbar .left{
      float:left;
      white-space:nowrap;
      }
      .bld{font-weight:bold;}
      #ygrp-grft{
      font-family:Verdana;
      font-size:77%;
      padding:15px 0;
      }
      #ygrp-ft{
      font-family:verdana;
      font-size:77%;
      border-top:1px solid #666;
      padding:5px 0;
      }
      #ygrp-mlmsg #logo{
      padding-bottom:10px;
      }

      #ygrp-vital{
      background-color:#e0ecee;
      margin-bottom:20px;
      padding:2px 0 8px 8px;
      }
      #ygrp-vital #vithd{
      font-size:77%;
      font-family:Verdana;
      font-weight:bold;
      color:#333;
      text-transform:uppercase;
      }
      #ygrp-vital ul{
      padding:0;
      margin:2px 0;
      }
      #ygrp-vital ul li{
      list-style-type:none;
      clear:both;
      border:1px solid #e0ecee;
      }
      #ygrp-vital ul li .ct{
      font-weight:bold;
      color:#ff7900;
      float:right;
      width:2em;
      text-align:right;
      padding-right:.5em;
      }
      #ygrp-vital ul li .cat{
      font-weight:bold;
      }
      #ygrp-vital a {
      text-decoration:none;
      }

      #ygrp-vital a:hover{
      text-decoration:underline;
      }

      #ygrp-sponsor #hd{
      color:#999;
      font-size:77%;
      }
      #ygrp-sponsor #ov{
      padding:6px 13px;
      background-color:#e0ecee;
      margin-bottom:20px;
      }
      #ygrp-sponsor #ov ul{
      padding:0 0 0 8px;
      margin:0;
      }
      #ygrp-sponsor #ov li{
      list-style-type:square;
      padding:6px 0;
      font-size:77%;
      }
      #ygrp-sponsor #ov li a{
      text-decoration:none;
      font-size:130%;
      }
      #ygrp-sponsor #nc {
      background-color:#eee;
      margin-bottom:20px;
      padding:0 8px;
      }
      #ygrp-sponsor .ad{
      padding:8px 0;
      }
      #ygrp-sponsor .ad #hd1{
      font-family:Arial;
      font-weight:bold;
      color:#628c2a;
      font-size:100%;
      line-height:122%;
      }
      #ygrp-sponsor .ad a{
      text-decoration:none;
      }
      #ygrp-sponsor .ad a:hover{
      text-decoration:underline;
      }
      #ygrp-sponsor .ad p{
      margin:0;
      }
      o {font-size:0;}
      .MsoNormal {
      margin:0 0 0 0;
      }
      #ygrp-text tt{
      font-size:120%;
      }
      blockquote{margin:0 0 0 4px;}
      .replbq {margin:4;}
      -->







      __________________________________________________
      Fale com seus amigos de graça com o novo Yahoo! Messenger
      http://br.messenger.yahoo.com/

      [Non-text portions of this message have been removed]
    Your message has been successfully submitted and would be delivered to recipients shortly.