Kreatus (Ubot Ninja) 422 Posted June 17, 2010 Report Share Posted June 17, 2010 Hi please advice on how to select and use the specific row and column in a .csv file. For example in this file http://www.awebsitesdirectory.com/test.csv I want to select only blogpost title 3 and use that to fill up a form. How can I do that? I watch the csv tutorial but i cannot find on how to do this.. Really need this.. Quote Link to post Share on other sites
Net66 54 Posted June 17, 2010 Report Share Posted June 17, 2010 Hi please advice on how to select and use the specific row and column in a .csv file. For example in this file http://www.awebsitesdirectory.com/test.csv I want to select only blogpost title 3 and use that to fill up a form. How can I do that? I watch the csv tutorial but i cannot find on how to do this.. Really need this..Read file into list using list from file. This will make a list with each item consisting of a comma delimeted line. When you want to use a specific entry clear a new list and use list from text choosing the line you want and telling ubot to delimit by comma. This will give you a list that contains the entries you want in positions 0,1 and 2 respectively. Andy 1 Quote Link to post Share on other sites
Kreatus (Ubot Ninja) 422 Posted June 17, 2010 Author Report Share Posted June 17, 2010 Read file into list using list from file. This will make a list with each item consisting of a comma delimeted line. When you want to use a specific entry clear a new list and use list from text choosing the line you want and telling ubot to delimit by comma. This will give you a list that contains the entries you want in positions 0,1 and 2 respectively. Andy Hi Andy appreciate your reply. I know how to select specific row but only in the first line. Please see the attach ubot file. I used the same csv file here http://www.awebsitesdirectory.com/test.csv How can I select "blogpost title 3" only and fill the form with it? Im stuck with this... Thanks in advance..select csv.ubot Quote Link to post Share on other sites
MiriamMB 63 Posted June 17, 2010 Report Share Posted June 17, 2010 actually, Net66 explained this perfectly. You can also check out the Working With CSV files Tutorial at http://ubotstudio.com/tutorials.aspx I think that very issue you are dealing with is addressed there too. Quote Link to post Share on other sites
Kreatus (Ubot Ninja) 422 Posted June 17, 2010 Author Report Share Posted June 17, 2010 actually, Net66 explained this perfectly. You can also check out the Working With CSV files Tutorial at http://ubotstudio.com/tutorials.aspx I think that very issue you are dealing with is addressed there too. Hi Lily I already watched all the tutorials there. I know its in the csv tutorial but I'm confused.. If you check my ubot file its selecting the specific row in the first line. But what I want to know is how to select the specific row in the next lines.. Can someone edit my attached ubot above and make the necessary changes so i can check what I am missing please.. I will appreciate it.. Thats all I wanted to know to move on to this project I am working right now.. Thanks Quote Link to post Share on other sites
alcr 135 Posted June 17, 2010 Report Share Posted June 17, 2010 Change the list position first to what row you want, and then use list item to get the column you want. 1 Quote Link to post Share on other sites
Kreatus (Ubot Ninja) 422 Posted June 17, 2010 Author Report Share Posted June 17, 2010 Thanks aclr! Actually I already tried that but it didnt work now I know the reason I put the "set list position" in a wrong position.. I tried to change the position of it just now and voila it worked! Problem solved! thanks guys.. Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.