AutoHotkey Community

cLue · Guest

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

cLue · Guest

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

trueski · Joined: 08 Apr 2008 Posts: 92 Location: Minnesota, USA

neXt · Joined: 18 Mar 2007 Posts: 505

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 Embarassed

.

Ok, i spent a few hours trying to read my own code Laughing

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 Embarassed

.
_________________
simplified csv - easy way to handle csv files.

SoLong&Thx4AllTheFish · Joined: 27 May 2007 Posts: 4999

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

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

kdoske · Joined: 17 Dec 2008 Posts: 80

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

neodrac23 · Joined: 16 Oct 2011 Posts: 21 Location: Charlotte

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?
Embarassed

Guest · Posted: Sun Oct 16, 2011 7:58 am Post subject: Re: Help for a noob