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:
a20100325.txt
col1 col2 col3
11 22 33
b20100325.txt
col1 col2 col3
44 55 66
c20100325.txt
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:
| A | |
| 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.