Oct 26, 2010, 7:19 AM
Post #1 of 2
The best way to get value out of an Excel table?
I have tables as shown below. We created them in Excel and save them as tab deliminated text files to be read by Perl at runtime.
DB2C DB2D_DEV DB2D_TST
MF_HOST s1a s12 s1a
MF_PORT 3606 3606 3606
DB2LOAD CSSCI.DB2C.DSNLOAD TSSCI.DB2D.DSNLOAD TSSCI.DB2D.DSNLOAD
DB2EXIT CSSCI.DB2C.DSNEXIT TSSCI.DB2D.DSNEXIT TSSCI.DB2D.DSNEXIT
What's the best way to store them and read them? I can use the following code to store them in a two dimensional array, but to find what I want, e.g. the DB2LOAD of DB2C, I have to search the whole array?