AutoHotkey Community

Isn't that not going to be able to properly handle CSV? For example:

@krogdor, note the IF statement I tried it and it does work. I simply made two loops one for CSV one for other delimiters, but this works as well.[/code]

HugoV nice catch, updated. Thanks!

Don't you think that 2 loops is a bit messy for something like this:D ?

Krogdor I tested such statements and it works fine.
Something like this will also work thanks to Rhys's function.



BTW, i tested this on a 2000 line CSV file, take a second to read it, but after works very smooth.

Ah, didn't see that. Sorry.
Although, using a delimiter other than a comma will force it to be simply delimited by it, and not contained by quotes or anything (for example with a delimiter of ";", this;"will; not";work)
I dont know if you care about other delimiters enough to fully implement them, but if you do, DerRaphael wrote a function for just that purpose:
http://www.autohotkey.com/forum/viewtopic.php?t=32938

Thanks for your note, but the only separators that i think are worth looking into are: coma, space and tab.

What can I say, it was late [/quote]

Update, added a search function.

Update, added CSV_exists()

MsgBox % CSV_find("e") returns nothing with your test file? shouldn't it return 5,2? MsgBox % CSV_find("e",5) does return 2... Also if you have the _find what use is the Exist? If _find return anything it exists if it's empty it doesn't

CSV_exists() is much faster. If you'll look at how those functions get their result you'll see what i mean .

Hmmmm, you are right, i don't get it why is blank.
I'll look into it.

In _find change
to and it returns 5,2 as advertised

Yeah, but i just discovered another bug, every last element in the array has a new line attached to it and causes mismatch . I did fix it, but i was hoping to avoid using RegEx (they are slower than regular functions) .

Here is what i did:

I use StringTrimRight, cell_XY, cell_XY, 1 ; trim trailing , or `n or perhaps
include an ignore character in your loop: loop parse, r_file, `n
(note `n could be a delimiter in a multiline CSV cell.
loop parse, r_file, `r, `n might be better)

Update, added CSV_sort()

Is it me or does your sort don't actually do any sorting
I don't see the difference between before/after sort when I do this: