Idea ID: 2874222

Need a way to access unique row randomly from csv file

Status : New Idea

Here is the scenario: 

 

Assume here is the test data:

               

Row No

UserId

Pssword

1

User123

pass123

2

User124

pass124

3

User125

pass125

4

User126

pass126

5

User127

pass127

6

User128

pass128

7

User129

pass129

8

User130

pass130

9

User131

pass131

  

Now, FileGetNextUniqueRow(hFile, true) will read the rows in sequence and will keep corresponding rows deleting. e.g. It will read #1 and then delete from csv. For next vUser, it will read #2 and delete from csv.

 

While need Silk to read the rows randomly and delete corresponding row. i.e. Read #3 and delete from CSV again read #9 and delete from CSV. Read #1 and delete from CSV.

Labels:

Scripting & APIs