How to solve the data problem

Tools: Excel+Putty+WinSCP+DB2

1 Operations of Excel Funtion: find、len、mid、countif、vlookup

   sheet1

   

   E2=FIND("</sex>",D2,1)=FIND("<sex>",D2,1)+LEN("<sex>")

   F2=FIND("</sex>",D2,1)

   G2=MID(D2,E2,F2-E2)

   H2=COUNTIF(G:G,G2)

   sheet2

   

  =VLOOKUP(A2,Sheet1!B:G,6,FALSE)

2 save the excel as 1.csv file. CSV file is splited by commar.

    

3 upload the csv file to mdm server.

4 create a new tempotary table named 1_temp,including three fields:name,phone and age.

4 run the follwing command to connect to DB2 database and import the csv to database;

   db2;

   connect to MDMDB;

   import from 1.csv of del insert into 1_temp;

   export to 2.csv of del select * from 1_temp

5 query the data what we need from the multiple table.