Trouble reading in tab delimited data

[omar]

I need some help writing a some code to read in a tab separated data

I've tried this:

Code: Select all

spreadsheetdata_row := StrSplit(%Clipboard%, %A_Tab%)

MsgBox, % spreadsheetdata_row.3

And this:

Code: Select all

spreadsheetdata_row := StrSplit(%Clipboard%, A_Tab)

MsgBox, % spreadsheetdata_row.3

Neither work.

What am I doing wrong?

Thanks.

[andymbody]

Neither work. What am I doing wrong?

Almost there. but this will give you COLUMN 3, not row 3

Code: Select all

str := "One`tTwo`tThree`tFour"
Clipboard := str
spreadsheetdata_COLUMN := StrSplit(Clipboard, A_Tab)
MsgBox, % spreadsheetdata_COLUMN.3

[omar]

@andymbody Amazing
Thanks