Trouble splitting comma separated data into array Topic is solved

[omar]

I'm reading in from clipboard some data like this:

abc,123
efg,456
xyz,999

I want to read each line and then get the 2 items read into a variable

I'm trying this:

Code: Select all

Loop, parse, clipboard, `n, `r
{
StringSplit, myArray, A_LoopField, `,
MsgBox % myArray[1] + myArray[1]
}

Not working.
What am I doing wrong?
Thanks.

[mikeyww]

AHK uses + to indicate mathematical addition in expressions.

Code: Select all

Clipboard =
(
abc,123
efg,456
xyz,999
)
Loop, Parse, Clipboard, `n, `r
{
 part := StrSplit(A_LoopField, ",")
 MsgBox % part[1] "`n" part[2]
}

Concatenation

[omar]

Amazing
Thank you

[omar]

@mikeyww I have a small problem

My data is:

abc,123
efg,456
xyz,999

Now I copy this into clipboard.
But the final line has a new line character.
So the loop gets executed one extra time.

I've tried trimming the clipboard by using trim(Clipboard)
Doesn't seem to work.

Any ideas?

Thanks.

[mikeyww]

Code: Select all

n := 0
Clipboard =
(
abc,123
efg,456
xyz,999



)
Loop, Parse, % Trim(Clipboard, "`n"), `n, `r
 MsgBox,, % "Result #" ++n, % (part := StrSplit(A_LoopField, ",")).1 "`n" part.2

[omar]

@mikeyww That's awesome
I get stuck on this SAME problem again and again and forget the answer
This time I have made a bookmark!