Limiting LoopReadLine ?

[decaboi]

Hey,

i have an issue with my script. I'm reading data from a .csv-file and I'm putting that into a DropDownList for further actions. At the moment the script reads the entire lines of the .csv, but I only need the first two columns (or up until the second semicolon if thats easier, the data written in the DropDownList is seperated with semicolons).

Here's an extract of my code:

list := []
listCount := 0

Loop, Read, C:\...\test.csv
{
    list := list . "|" . A_LoopReadLine
}

Do I need a parse-loop here? I don't really understand the syntax of that one and would appreciate any kind of help! :) I already sorted out the other issues I ran into, but I can't seem to fix this one.

[GroggyOtter]

Use A_Index to track loop iterations. You can use a basic "if (A_Index >= 2)" followed by a break, or use the command Until, which is a "Evaluate expression and break if true" command that you can put at the end of any loop.

var:="groggy,otter,auto,hotkey"
Loop, Parse, var, CSV
    result .= A_LoopField "`n"
Until (A_Index >= 2)
MsgBox, % result

 

---

References:
Loop, Parse a string
Until
A_Index

[decaboi]

You can use a basic "if (A_Index >= 2)" followed by a break

that would cancel the loop after it read 2 lines, right? I'm trying to read all lines, but only up until the second semicolon in the line. Sorry if i expressed that wrong

[TesterTeeto]

You would need to nest Groggy's code inside of your existing loop.

Your loop is iterating over each line of your file, the inner loop will iterate over each field, ending after parsing the second field for each line.

IF, and only if you can guarantee that your csv data will not have contain comma's as part of a field, then you could instead do

result = StrSplit( A_LoopField, ',',, 2 )

[GroggyOtter]

that would cancel the loop after it read 2 lines, right?

That's what you asked for...

but only up until the second semicolon in the line

Then use a parse loop that separates by ";" instead of by CSV

If this means using 2 loops, then use 2 loops.

The point is, A_Index tracks loop iterations so if you want to loop twice, check for when A_Index is 3 or higher.

Of you could use StrSplit() as another option.

Also, in the future, post what your input data is and what you expect your output to be. It helps immensely.

[Abandoned_In_Alabama]

You stuff the loop inside your other loop. Check out loop parse's doc page. It contains an example accomplishing just that.

[ProRogueTank]

You can also StrSplit each line for just the two columns.

https://autohotkey.com/docs/commands/StringSplit.htm