解析 CSV 文件时的 ListGetAt 问题 [英] ListGetAt Issues when parsing CSV file

问题描述

我有一个脚本，它正在从客户端读取 CSV 文件，并将值拆分为稍后将进入数据库的变量.

I have a script that is reading CSV files from clients and is splitting the values into variables that will later on enter the database.

这是当 CSV 包含的列数少于所需的最小值时出现的错误.

This is the error I am getting when a CSV comes in with less columns than the required minimum.

In function ListGetAt(list, index [, delimiters]), the value of index, 11, is not a valid as the first argument (this list has 10 elements). Valid indexes are in the range 1 through the number of elements in the list.

Expression

Invalid list index 11. 

这是代码示例

    <cfscript>
            csvData = csvloaderCFC.loadCSVfile(csvfilename);
    </cfscript>



    <cfset i=0>



<!---  loop CSV Data ---->

<cfloop index="line" list="#csvData#" delimiters="#chr(10)##chr(13)#">

<!---  Ignore 1st Row ---->
        <cfif i EQ 0>
            <cfset i++>
              <cfscript>
                continue;
            </cfscript>
         </cfif>

                       <!--- Split CSV file --->
           <cfscript>
           line = csvloaderCFC.listfix(line);
            ClientBrandID =  (listgetAt('#line#',1) EQ 'NULL')?'':listgetAt('#line#',1);
            SurveyType =  (listgetAt('#line#',2) EQ 'NULL')?'':listgetAt('#line#',2);
            Location= (listgetAt('#line#',3) EQ 'NULL')?'':listgetAt('#line#',3);
            ClientContactID =  (listgetAt('#line#',4) EQ 'NULL')?'':listgetAt('#line#',4);
            FirstName=  (listgetAt('#line#',5) EQ 'NULL')?'':listgetAt('#line#',5);
            LastName=  (listgetAt('#line#',6) EQ 'NULL')?'':listgetAt('#line#',6);
            HomePhone=  (listgetAt('#line#',7) EQ 'NULL')?'':listgetAt('#line#',7);
            WorkPhone=  (listgetAt('#line#',8) EQ 'NULL')?'':listgetAt('#line#',8);
            CellPhone=  (listgetAt('#line#',9) EQ 'NULL')?'':listgetAt('#line#',9);
            Email =  (listgetAt('#line#',10) EQ 'NULL')?'':listgetAt('#line#',10);
            BirthDate= (listgetAt('#line#',11) EQ 'NULL')?'':listgetAt('#line#',11);
            Zip= (listgetAt('#line#',12) EQ 'NULL')?'':listgetAt('#line#',12);
            Gender= (listgetAt('#line#',13) EQ 'NULL')?'':listgetAt('#line#',13);
            InquiryDate= (listgetAt('#line#',14) EQ 'NULL')?'':listgetAt('#line#',14);
            ScheduledBy= (listgetAt('#line#',15) EQ 'NULL')?'':listgetAt('#line#',15);
            ConsultServiceType= (listgetAt('#line#',16) EQ 'NULL')?'':listgetAt('#line#',16);
            ConsultDate= (listgetAt('#line#',17) EQ 'NULL')?'':listgetAt('#line#',17);
            ConsultantName= (listgetAt('#line#',18) EQ 'NULL')?'':listgetAt('#line#',18);
            ServiceType= (listgetAt('#line#',19) EQ 'NULL')?'':listgetAt('#line#',19);
            ServiceDate= (listgetAt('#line#',20) EQ 'NULL')?'':listgetAt('#line#',20);
            ServiceProviderName= (listgetAt('#line#',21) EQ 'NULL')?'':listgetAt('#line#',21);
            ServiceRevenue= (listgetAt('#line#',22) EQ 'NULL')?'':listgetAt('#line#',22);
            LeadSource= (listgetAt('#line#',23) EQ 'NULL')?'':listgetAt('#line#',23);

            </cfscript>

<!--- SQL Code begins here --->

我需要修改我的代码，以便能够处理较小的文件，以确定它们是否包含所有列，因为这些也是有价值的信息.

I need to modify my code to be able to process smaller files regarding if they include all of the columns or not because those are valuable information as well.

推荐答案

停止使用 ListGetAt - 这不是为 CSV 文件格式设计的 - 而是使用适当的 CSV 解析器，例如 OpenCSV.

Stop using ListGetAt - this is not designed for the CSV file format - and instead use a proper CSV parser, such as OpenCSV.

这里有一些示例代码:

<cfscript>
    fileReader = createobject("java","java.io.FileReader");
    fileReader.init("c:	hefile.csv");
    csvReader = createObject("java","au.com.bytecode.opencsv.CSVReader");
    csvReader.init(fileReader, ",");
    ArrayData = csvReader.readAll()
</cfscript>

(取自:http://www.bennadel.com/blog/1903-Parsing-CSV-Data-With-ColdFusion-s-CFHTTP-Tag.htm#comments_26608 )

这篇关于解析 CSV 文件时的 ListGetAt 问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！