Forum Discussion

GAutomation's avatar
GAutomation
Frequent Contributor
7 years ago
Solved

how to compare the items in the witemlist and the values passed in excel sgould be equal.

we are running a regression with keyword driven framewrok and wanted to write a vb script code to compare list of values in the combobox  that are passed in the excel is matching the witemlist.   ...
tristaanogre's avatar
tristaanogre
Esteemed Contributor
7 years ago

As noted, wItemList is a list with a separator character, most likely a CR character.  So, if you want to compare the two lists, you'll need to process wItemList to format it in the same formate as the Excel sheet... OR... format your excel sheet to match what is in wItemList.  You can use aqString.GetListLength, aqString.SeparatorCharacter, aqString.GetListItem, etc., to process the string of data in wItemList.