Open url through csv

csv file have value in A1 and A2


gmail.com

pl. guide me how to automate it.?

Dont do we have any kind of video tutorials?

See here: Open url from csv

  1. I have values in csv file (a1 a2 a3 b1 b2 b3 c1 c2 c3 )
  2. I do wanted to open all but one by one.
  3. With your demo i am able to open it a1 b1 c1 by
    “Target”: "{!col1} "Target": "{!col2}
    “Target”: "${!col3}
  4. Guide me how to open a2 a3 b2 b3 c2 c3
    attaching pic.

its 17 days over and this post seems not come in your eyes.
Requesting you to look in it and guide me please.
Thanks

Guide me how to open a2 a3 b2 b3 c2 c3

If you start the macro with the LOOP button, it will read a new CSV line with each loop

  • a1 b1 c1 in first run
  • a2 b2 c2 in 2nd run
  • and so on

Does this answer the question?

No.
Let me cut short the question.
see,

  1. your Demo is running Left to Right, means A1B1C1.
    BUT
  2. I need to run it
    Top to
    Bottom, means
    A1
    A2
    A3.
    I hope this time i will get my answer.
    Thanks for your time and help.

Just to clarify, so you need

A1
A2
A3

and then

B1
B2
B3

…and so on?

you understood it correctly.
Thanks

I can understand that you are very busy. As you are masters so it does not take your more then 10 min, but it will solve the problem and days for others.

May I request you again Please.

The “trick” here is to use !csvReadLineNumber to reset the read position to the first line. You can use the DemoCsvReadWithWhile macro that ships with Kantu as starting point.

  • This reads everything in column A
  • csvRead | ReadCSVTestData.csv
  • while | ${!csvReadStatus} == "OK"
  • echo | ${!col1}
  • csvRead | ReadCSVTestData.csv - read value of next row (if any)
  • endWhile

  • store | 1 | !csvReadLineNumber - reset CSV read position to top of file

  • This reads everything in column B
  • csvRead | ReadCSVTestData.csv
  • while | ${!csvReadStatus} == "OK"
  • echo | ${!col2} - same code as above, but now we use column 2
  • csvRead | ReadCSVTestData.csv
  • endWhile
1 Like

Thank you for reply BUT i am sorry, you did not reply what i need for.
see this pic again.


I am again saying the same thing that i need
T
o
p
e
To
B
o
t
t
o
m

Not LEFT to Right
I hope i am clear now.

This is what my code will do. It first reads all entries in column A, and then in column B (starting again at the top).

Many thanks for your reply and patience,
I think its easy and clear for others but for me its not. Let me rephrase the question.

Only I need
A1
A2
A3
image

Guide me pl.

…but if you only need A1 to A3, then this is normal CSV reading sequence. Please see the DemoCsvReadWithWhile macro that ships with Kantu - it does exactly this.

Can we do it without using any loop?
I hope there must be simple and easy way available with you guys.