Export Dynamic Text Files to Database with esProc

Uncategorized 620 0

Problem source: http://bbs.csdn.net/topics/330190185 . 

There are multiple text files in a certain directory. Each of their names includes one of the letters a/b/c at the beginning and a date. The letter is fixed while the date is dynamic. You need to write contents of these files as well as the dates into a database table by a specified date. The text files are as follows:


col1 col2 col3

11    22    33 


col1 col2 col3

44    55    66 


col1 col2 col3

77    88    99 

The expected database table, tb1, after data export is as follows:

col1 col2 col3 d_date

11    22    33    20100325

44    55    66    20100325

77    88    99    20100325 

esProc script for doing this:

1 [a,b,c]
2 =A1.(file(“E:\\”+~+string(ddate)+”.txt”).import@t()).conj().derive(ddate:d_date)
3 >db.update@i(A2,tb1,col1,col2,col3,d_date)

A1: A sequence composed of a, b, c.

A2: Import text files named after the three letters in A1 and the dates specified by parameter ddate by loop. Merge the three files using conj() and add a date column (d_date) with derive. Then enter the dates as values of the newly added column. 


A3: Update the table tb1 with A2’s result. @i means inserting data only. 

Leave a Reply

Hi,You need to fill in the Username and Email!

  • Username (*)
  • Email (*)
  • Website