willut72 0 Posted August 13, 2014 Report Share Posted August 13, 2014 I've been searching around and haven't found a solution yet. I am sure this is doable, if I remember correctly there is some type of format data has to be in in order to get items to list sepearately when adding an item to a list. I have a variable Customer = Number Type Description Release DateStatus 12345OutsideLetter Regarding Notification #1234505/29/2014Open 14785Internal Email and Letter Regarding Notification #1478503/09/2009Closed 98741OutsideEmail and Letter Notification Regarding #9874102/08/2011Closed 85214OutsideCall, Email, and Letter Notification Regarding #8521403/18/2014Open 96589InternalEmail and Letter Notification Regarding #9658906/08/2009Closed 11447InternalLetter Regarding Notification #1144704/04/2013Closed What I need to do is get each of these items listed as an individual item so that I can break them up into a table, adding them as a list from this variable just puts them in the same format (as one item). The ultimate goal is to get the data into a table. Any help on how to break these up would be greatly appreciated. Thanks!Will Quote Link to post Share on other sites
HelloInsomnia 1103 Posted August 13, 2014 Report Share Posted August 13, 2014 Let me preface this by saying that this is not an ideal situation but if you are 100% positive that the data will always be like that then this is one of the ways you can do it. But I really think you should be scraping each individual variable directly into the correct table cell for best results, maybe if you tell us how you are getting these list items like that it would be helpful and show us where you are getting them from so we can give you a better answer. But in a pinch this will work (added a few of your list items into there to show how it works) clear table(&data) set table cell(&data, 0, 0, "Number") set table cell(&data, 0, 1, "Type") set table cell(&data, 0, 2, "Description") set table cell(&data, 0, 3, "Release Date") set table cell(&data, 0, 4, "Status") clear list(%items) add item to list(%items, "12345 Outside Letter Regarding Notification #12345 05/29/2014 Open", "Delete", "Global") add item to list(%items, "14785 Internal Email and Letter Regarding Notification #14785 03/09/2009 Closed", "Delete", "Global") add item to list(%items, "98741 Outside Email and Letter Notification Regarding #98741 02/08/2011 Closed", "Delete", "Global") set(#row, 1, "Global") loop($list total(%items)) { clear list(%split) add list to list(%split, $list from text($next list item(%items), $new line), "Delete", "Global") set(#column, 0, "Global") loop($list total(%split)) { set table cell(&data, #row, #column, $next list item(%split)) increment(#column) } increment(#row) } Quote Link to post Share on other sites
drhum 3 Posted August 16, 2014 Report Share Posted August 16, 2014 Hi Willut, just checking on this. Did it worked for you already? 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.