douyang2530 2014-10-09 07:07
浏览 113
已采纳

csv解析器用于一个csv文件中的标题和详细信息行

I have a requirement to import an order from a customer which will contain about 4 fields on the first row as their customer data i.e.

customer number, order date, order no, delivery date

The next X number of lines will contain two fields with the product code and quantity required.

I have other procedures that will pull in a standard price list etc and parse, but I am struggling to get my head around how to break apart the CSV file into the two different sections.

Any help or ideas on how this can be achieved will be appreciated

  • 写回答

2条回答 默认 最新

  • dongliang1865 2014-10-09 07:19
    关注

    I will suggest using this library, its will give you column by name similar to sql result array

    customer number, order date, order no, delivery date
    

    Parse it in a way you want https://github.com/parsecsv/parsecsv-for-php

    example

    require_once 'parsecsv.lib.php';
    $csv = new parseCSV('data.csv');
    print_r($csv->data);
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 maccms影视模板 制作影视网站失败 求
  • ¥15 stm32按键设置闹钟数进退位不正常
  • ¥15 三电平逆变器中点电位平衡问题
  • ¥20 这怎么写啊 java课设
  • ¥15 用C语言完成一个复杂的游戏
  • ¥15 如何批量更改很多个文件夹里的文件名中包含文件夹名?
  • ¥50 MTK手机模拟HID鼠标出现卡顿
  • ¥20 求下下面这个数据结构代码
  • ¥20 前端 二进制文件流图片转化异常
  • ¥15 github上的这个C语言项目如何跑起来