read random entry from csv

[Fox]

is it possible that i can read an random entry from an csv file... and write this result in an label...

is here one that have an example for me how can i realize that?!

Help would be nice.

 

[Erel]

You will need to read the complete file (with StringUtils) and then randomly choose one row.

 

[enonod]

This is what I used...

Dim sTest() as String
...

Sub CSV
    Dim su As StringUtils
    Dim csv As List
    csv = su.LoadCSV(File.DirAssets, "tests.txt", ",")
    sTest = csv.Get(0)
End Sub

Tick the String utils Library in the IDE Libs tab
Put the file in the Files folder under your project.
Then in the main code, for example, access sTest(7)