AutoHotkey Community

First of all I have to thank you for the great work - very helpful!

But I tested the script and identified several errors:

1) CSV_writeCell and XLS_writeCell do not change the var. __line%row%
- Statement should be : __line%row% := regExReplace(__line%row%, __matrix%row%_%column%, Format4CSV(value))

2) To have all changes reflected in the .csv using finalize_CSV the r_updated value should be set to false using r_updated = false (not := false)
or the if statement within the finalize_CSV should be changed to: if(r_updated = false) (not: r_update = "false")

Regards

I built functions for adding or removing rows (quick and dirty as I'm in a hurry):



Maybe somebody will clean it up a bit
cLue
[/b]

Remove function works fine once, but when attempting to delete multiple rows the entire array will be erased or rows become duplictated, or nothing happens at all

_________________
-trueski-

I haven't done any debugging with writing values since i don't ever need to use them, makes me sad how broken these functions are .

Ok, i spent a few hours trying to read my own code and made some fixes with writing and finalizing functions. The only problem is it's not writing the very last line in csv file.
I'll try to fix that and implement suggested changes and functions in the original code/post in a short period of time.

P.S. Original post updated. I ran a few quick test and it seems to be writing values and saving copies just fine now.
P.P.S. There is one more bug that i have no idea how to fix as of now. If Any row contains duplicate data in separate columns and you attempt to overwrite only the later value, both will be overwritten. For instance if your row contains "1,2,3,1,4" and you need to overwrite only the fourth column, not the first one, function will replace both .

@neXt you did see trueskis' version here http://www.autohotkey.com/forum/topic42843.html

_________________
AHK FAQ
TF : Text files & strings lib, TF Forum

I actually updated trueskis libary even more by adding more features and making it more reliable. It can be seen here:

Updated CSV Library - http://www.autohotkey.com/forum/viewtopic.php?p=341189#341189

I just want to search a xls file, search by variable and return row to separate variable.
this is simple in perl, grep... but it's killing me in ahk, HELP Please?

a) you are using the wrong library (if you work with CSV the kdoske one above is better OR use the table data library by VxE)
b) if you work with actual XLS files none of the CSV/TABLE libraries are of use as they don't work with binary files, you need COM like http://www.autohotkey.com/forum/topic70 ... =excel+com
So, try again