MaximusAurelius 0 Posted December 29, 2015 Report Share Posted December 29, 2015 (edited) Hey Guys,I scraped a list that ended up pulling a full address and I want to parse end one of the line items to columns in a table (see attached picture), how do I do this? I tried 'add the list to table as column', but when I save it to a CSV and then open the file, only the first line ("Amf") of the whole address was saved. Looking to have each line go to a different column (Name, Address, phone #, etc.)Any idea? Probably an easy fix but I can't figure it out. Edited December 29, 2015 by MaximusAurelius Quote Link to post Share on other sites
web4you.pro 3 Posted December 30, 2015 Report Share Posted December 30, 2015 You use:create table from text Quote Link to post Share on other sites
pash 504 Posted December 30, 2015 Report Share Posted December 30, 2015 try comment("Ubot command save to csv bug if data have \",\"") set(#Text,"Video Training in en Minutes or Less","Global") set(#Text,$replace(#Text,",",""),"Global") set table cell(&Table,0,0,"Name") set table cell(&Table,0,1,"Address") set table cell(&Table,0,2,"Phone") add list to list(%TableRow,$list from text(#Text,$new line),"Delete","Global") add list to table as row(&Table,1,0,%TableRow) 1 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.