Read and Process CSV

[veeco]

Hello,
on create an account, i would like to set the some field manually like email and password. Therefore i create a manual data with CSV:

Email, Password
[email protected],123456
[email protected],787878


now how can i parse this csv list ? can i parse them in a loop ?

Thanks ?

 

[Hungry Bulldozer]

You can get line into a variable and then do "To list" via "Word processing". There you can specify separator. Oк you can go with a table by reading data from table and put cells to variables.

 

[veeco]

How to get line by line ? coz if i use "take text", it took the whole content into single variable

You can get line into a variable and then do "To list" via "Word processing". There you can specify separator. Oк you can go with a table by reading data from table and put cells to variables.

 

[rostonix]

Splitting data to variabes: http://wiki.zennolab.com/lib/exe/fetch.php?fake=&media=en:table_action_get_string_eng.png

About loops: http://wiki.zennolab.com/doku.php?id=en:looping

 

[zxcvbn]

Another way could be to take delimited txt file as input and read one line. Put that line in a table and use table processing to read it column wise.