colton 13 Posted May 3, 2013 Report Share Posted May 3, 2013 What is the best way to take one comma separated variable and turn it into multiple different variables. Essentially I am running a csv file to show tempVar as next list item but not every list item has the same number of columns. This is what I have CSV Contact listtom,555-555-5555,123 Test Street Dallas Texas, testwebsiteurl.comsally,666-666-6666, 118 Test Drive Daytona Florida, (no website)hank, 111-111-1111, 5454 Test Ave Seattle Washington, (no website)linda, 222-222-2222, 432 Test Lane Denver Colorado, lindaswebsiteexample.com This is what I am trying to do add list to list{contactList}{list from file .csvfile} loop total contactList set tempVar {next list item {contactList}} separate tempVar into nameVar,phoneVar,addressVar,webVar(if it exist) perform task Quote Link to post Share on other sites
AutomationNinja 194 Posted May 3, 2013 Report Share Posted May 3, 2013 Use the "add list to a table as a column" command 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.