9 Replies Latest reply on Oct 1, 2009 7:38 AM by emmim44

    CSV File Reading Help

    emmim44 Level 1

      I need to exclude the column names which are the first row of the file...Currently, I am not able...Any help appreciated..

       

      EID Score

      -----------

      e1  100

      e2 200

       

      :::code:::

         <cffile action="read" file="#CurrDir#SC_Flat.csv" variable="csvfile">
           <!---cfdump var="#csvfile#"--->
           <!--- loop through the CSV-TXT file on line breaks and insert into database --->
           <cfloop index="index" list="#csvfile#" delimiters="#chr(10)##chr(13)#">
           <cfoutput>#listgetAt('#index+1#',1, ',')#<br /></cfoutput>

       

      </cfloop>