条件に一致するデータを抽出します。
ここでは、「販売日が2008年」、「商品名が冷蔵庫」および「店舗名が博多店」の3つに一括仕分け(抽出)します。
$SALESDATE = '^2008' ・・・ 販売日の先頭が"2008"という文字列で始まるデータを抽出します $GTYPE = '冷蔵庫' ・・・ 商品名に"冷蔵庫"という文字列を含むデータを抽出します $NMTENPO = '博多店' ・・・ 店舗名に"博多店"という文字列を含むデータを抽出します |
■入力ファイル
入力ファイルは、「2.2 データを連結する」で連結した結果を使用します。
《 result\1_連結結果.csv 》
"SALESDATE","STORECODE","NMTENPO","LOCATION","CDTYPE","GTYPE","CDMAKER","NUMBER","SALEPRICE" "2007-01-01","1000","本店","駅前","CPH-02W","据え置き型CDプレイヤーTSB2-001","7","1","43300" "2007-01-02","1000","本店","駅前","TWD-01W","BOX型冷凍庫","5","1","16300" "2007-01-02","1000","本店","駅前","AC-01IW","インバータエアコン","10","1","284800" "2007-01-02","1000","本店","駅前","FK-03T","ドラム式洗濯機FK-T","3","1","14500" "2007-01-02","1000","本店","駅前","LT-01K","液晶テレビSSP4","5","1","1100" "2007-01-02","1000","本店","駅前","TV-03WK","ワイドテレビ03WK","10","1","198100" "2007-01-02","1000","本店","駅前","MOU-01K","マウス","5","1","1100" "2007-01-02","1000","本店","駅前","IR-01TK","テーブル一体型アイロン","5","1","43300" "2007-01-02","1000","本店","駅前","CD-01B","デジタルカメラTX2","3","2","115600" "2007-01-02","1000","本店","駅前","LCD-01OW","ポータブルDVDプレイヤー","10","1","29800" ・・・ |
