Open csv read and open from specific line

UI.Vision RPA HowTo
1

Hi I’m able to read csv and open each link using
var string = “${!col1}”; var stripped = string.replace(/[^A-Za-z0-9]/g, ‘’); stripped;

any body know ho to open from specific line for example start runing from the 200 line ?

thanks

2

Here the solution to read prefered line in csv

3

Thanks but I’m askinag how to run from specific line > for example in my csv there is 500 line
How I can run from the 200 line not from first

4

You must use this command !csvReadLineNumber and set the line to read

5

how did you resolve it?

pl. share the code.

6

Here code to read from line 50 of csv, you can customize the value and with executescript you can increment it.

{
“Command”: “store”,
“Target”: “50”,
“Value”: “!csvReadLineNumber”
},

7

i want to open all the url from csv from 50th line no.
here is the code which i am trying to run. but is not working for me.
{
“Name”: “z2.0”,
“CreationDate”: “2021-1-16”,
“Commands”: [
{
“Command”: “csvRead”,
“Target”: “url_500.csv”,
“Value”: “”
},
{
“Command”: “store”,
“Target”: “50”,
“Value”: “!csvReadLineNumber”
},
{
“Command”: “comment”,
“Target”: “store // 50”,
“Value”: “!csvReadLineNumber”
},
{
“Command”: “open”,
“Target”: “${!col1}”,
“Value”: “”
},
{
“Command”: “echo”,
“Target”: “${!col1}”,
“Value”: “”
},
{
“Command”: “waitForPageToLoad”,
“Target”: “10000”,
“Value”: “”
}
]
}

url_500.csv have only urls like
http://000webhost.com

etc…