Need help with parsing data from tsv file

HCL Domino Domino Forum
1

I have a tsv file where the content is separated with space. Like below example. How I get the second (test1), and third data (test.nsf) from each line?

0000001 Test1 test.nsf 15 testing

0000002 Test3B test3b.nsf 23 testing3B

Thanks!!!

2

Subject: Split() ?

Try to read the row using Line Input, then use Split() to split the values into an arrray, using Chr$(9) (Tab) as delimiter:

Line Input #, row

valueArray = Split(row,Chr$(9))

3

Subject: It works!

Thanks!!!

Have a nice weekend!!!