sfresher Posted September 25, 2008 Share Posted September 25, 2008 I was asking questions for reading .csv file into a 2D array. However, I am was also wondering if database processing is more suitable in my case. Let's say I want to write a test app, and all test input variables are stored on a data file (not in the script). If I want to add more stuff to test, I can simply add/remove data to the existing file, without modifying the dramatically. For example, Title|Name|Pay|Employee|Holiday|Company phone Engineer|James|90000|Yes|22 Engineer|Tina|75000|No|NA Outside Vendor|Apple Inc||||4088006000 Manager|Suzie|120000|Yes|10 Engineer|Don|50000|Yes|19 Boss|Jason|0|Yes|0 If i have I want to test more, I can simply add a line to the data file: Engineer|New|30000|Yes|0 or Outside Vendor|IBM Inc||||8003001234 My goal is, I want to easily read my test variable from array[Don][Pay], and compare with array[Tina][Pay]. The current challenge I am facing: 1. If it's an array, I cannot read the variable as array[Don][Pay], but array[6][2], which is not very intuitive. 2. The index of the array will be changed when new data add in, for example, array[6][2] may change to array[7][2] if I update the test input file later. Any suggestion? Link to comment Share on other sites More sharing options...
enaiman Posted September 25, 2008 Share Posted September 25, 2008 IMO, the best way to do this is to keep your data always in a file (csv, spreadsheet or whatever else) - you can add new lines to that file, remove lines ... When your script will be processing data from that file, the best way to do it will be to open the file, read all the file in one array, close the file and do all the processing using the array you have in memory, after all is done, you can write the new array to the file. This way has a couple advantages: you are working with data which is in memory so the processing speed will be better (reading values from the file sequentially is slower) and the 2nd advantage: you won't keep the file open for long time (maybe someone else need to edit that file). SNMP_UDF ... for SNMPv1 and v2c so far, GetBulk and a new example script wannabe "Unbeatable" Tic-Tac-Toe Paper-Scissor-Rock ... try to beat it anyway :) Link to comment Share on other sites More sharing options...
DjDeep00 Posted September 25, 2008 Share Posted September 25, 2008 @sfresher...Why not just use a database? Look up SQLite in the helpfile. Link to comment Share on other sites More sharing options...
Moderators SmOke_N Posted September 25, 2008 Moderators Share Posted September 25, 2008 http://www.autoitscript.com/forum/index.ph...c=78776&hl= Common sense plays a role in the basics of understanding AutoIt... If you're lacking in that, do us all a favor, and step away from the computer. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now