Hello Friends,
In this post, we will see, how to get unique/distinct values from an array.
We will do that using very useful and optimum feature of QTP - Dictionary Object.
Here is the code--
Dim objDict, oldArray, val
oldArray = Array ("11", "21", "11", "31", "21", "41", "31")
Set objDict = CreateObject("Scripting.Dictionary")
objDict.CompareMode = vbTextCompare
For each val in oldArray
objDict(val) = val
Next
newArray = objDict.Items
For i=0 to ubound(newArray)
msgbox newArray(i)
Next
...n done!!!
Plz do post your queries/comments...
In this post, we will see, how to get unique/distinct values from an array.
We will do that using very useful and optimum feature of QTP - Dictionary Object.
Here is the code--
Dim objDict, oldArray, val
oldArray = Array ("11", "21", "11", "31", "21", "41", "31")
Set objDict = CreateObject("Scripting.Dictionary")
objDict.CompareMode = vbTextCompare
For each val in oldArray
objDict(val) = val
Next
newArray = objDict.Items
For i=0 to ubound(newArray)
msgbox newArray(i)
Next
...n done!!!
Plz do post your queries/comments...
Nice Code. It is reaching our expectations without any updates
ReplyDeleteHi,
ReplyDeleteNeed small change in below part of above mentioned code...
Incorrect One :
For i=0 to ubound(newArray)
msgbox newArray(i)
Next
Correct One :
For i=0 to ubound(newArray)-1
msgbox newArray(i)
Next
objDict.CompareMode = vbTextCompare
ReplyDeletewhat did this code ?
ll it run without this?
If you do without the Comparemode = vbTextCompare then the will be VbBinaryCompare. so any time if objDict found "11" & "11" binary values are different it will take as new value and you will get "11" 2 times.
ReplyDeleteSo to avoid that any point of time tell obDict to compare text wise.
How can you get items that only appear once. Meaning "41" only in the above mentioned array?
ReplyDelete@Deepak, you're wrong Ubound returns the highest index of an array. So the code above is correct.
ReplyDeleteFor each val in oldArray
ReplyDeleteobjDict(val) = val
Next
What the above code is doing?
Iot Training in Bangalore
ReplyDeleteArtificial Intelligence Training in Bangalore
Machine Learning Training in Bangalore
Blockchain Training bangalore
Data Science Training in Bangalore
Big Data and Hadoop Training in bangalore
Devops Training in Bangalore
nice blog
ReplyDeletehadoop training in chennai
Nice post. Thanks for sharing the valuable information. it’s really helpful. Who want to learn this blog most helpful. Keep sharing on updated posts…
ReplyDeleteData Science training in rajaji nagar | Data Science Training in Bangalore | Data Science with Python training in chennai
Data Science training in electronic city | Data Science training in USA
Data science training in pune | Data science training in kalyan nagar
Nice tutorial. Thanks for sharing the valuable information. it’s really helpful. Who want to learn this blog most helpful. Keep sharing on updated tutorials…
ReplyDeleteJava training in Chennai | Java training in Bangalore
Java online training | Java training in Pune
Nice tutorial. Thanks for sharing the valuable information. it’s really helpful. Who want to learn this blog most helpful. Keep sharing on updated tutorials…
ReplyDeleteadvanced excel training in bangalore | Devops Training in Chennai
I believe there are many more pleasurable opportunities ahead for individuals that looked at your site.
ReplyDeletepython course in pune | python course in chennai | python course in Bangalore
I am really happy with your blog because your article is very unique and powerful for new reader.
ReplyDeleteClick here:
selenium training in chennai
selenium training in bangalore
selenium training in Pune
selenium training in pune
Selenium Online Training
ReplyDeleteWhoa! I’m enjoying the template/theme of this website. It’s simple, yet effective. A lot of times it’s very hard to get that “perfect balance” between superb usability and visual appeal. I must say you’ve done a very good job with this.
AWS Training in BTM Layout |Best AWS Training in BTM Layout
AWS Training in Marathahalli | Best AWS Training in Marathahalli
Nice post. By reading your blog, i get inspired and this provides some useful information. Thank you for posting this exclusive post for our vision.
ReplyDeleteangularjs Training in btm
angularjs Training in electronic-city
angularjs online Training
angularjs Training in marathahalli
angularjs interview questions and answers
For Us i and my friends too finished double degree,but most of the technical experience i have got through your blog only.
ReplyDeleteMobile phone Battery replacement in chennai | Mobile phone unlocking service in chennai | 100% genuine mobile parts | Mobile service center in chennai | Mobile service center in chennai in chennai | Mobile phone glass replacement in chennai
Thanks for sharing such an informative post with us. I hope you will share more such post. Please keep sharing.
ReplyDeleteApple Service center in Ameerpet, Hyderabad
Best Laptop Service center in Ameerpet, Hyderabad
This comment has been removed by the author.
ReplyDeletethanks for Sharing such an Awesome information with us.
ReplyDeleteI learned World's Trending Technology from certified experts for free of cost.i Got job in decent Top MNC Company with handsome 14 LPA salary, i have learned the World's Trending Technology from Python training in pune experts who know advanced concepts which can helps to solve any type of Real time issues in the field of Python. Really worth trying Freelance seo expert in bangalore
Thanks for sharing information with us.This post is very attractive and useful for the users.The content provided is relevant to the topic.One can gain knowledge and have basic understanding by reading this blog.
ReplyDeletedata science training institutes in bangalore
Great Article
ReplyDeleteB.Tech Final Year Projects for CSE in Angular
Angular Training in Chennai
Project Centers in Chennai
JavaScript Training in Chennai
Great Article. Thank you for sharing! Really an awesome post for every one.
ReplyDeleteProject Centers in Chennai
JavaScript Training in Chennai
Final Year Project Domains for IT
JavaScript Training in Chennai
Wow, this is really interesting reading. I am glad I found this and got to read it. Great job on this content. I like it. 111 niche blogcomments
ReplyDeletemobile phone repair in Auburn Hills
ReplyDeleteiphone repair in Auburn Hills
cell phone repair in Auburn Hills
tablet repair in Auburn Hills
ipad repair in Auburn Hills
mobile phone repair Auburn Hills
iphone repair Auburn Hills
cell phone repair Auburn Hills
phone repair Auburn Hills
tablet repair Auburn Hills
It is perfect time to make some plans for the future and it is time to be happy. I've read this post and if I could I desire to suggest you some interesting things or suggestions. Perhaps you could write next articles referring to this article. I want to read more things about it!Your blog has very useful information about this technology which i am searching now, i am eagerly waiting to see your next post as soonI just got to this amazing site not long ago. I was actually captured with the piece of resources you have got here. Big thumbs up for making such wonderful blog page!Java training in Chennai
ReplyDeleteJava Online training in Chennai
Java Course in Chennai
Best JAVA Training Institutes in Chennai
Java training in Bangalore
Java training in Hyderabad
Java Training in Coimbatore
Java Training
Java Online Training
Thanks for sharing information with us.This post is very attractive and useful for the users.The content provided is relevant to the topic.One can gain knowledge and have basic understanding by reading this blog.
ReplyDeleteangular js training in chennai
angular training in chennai
angular js online training in chennai
angular js training in bangalore
angular js training in hyderabad
angular js training in coimbatore
angular js training
angular js online training
ReplyDeletevery nice blogs!!! i have to learning for lot of information for this sites...Sharing for wonderful information.Thanks for sharing this valuable information to our vision. You have posted a trust worthy blog keep sharing.
Azure Training in Chennai
Azure Training in Bangalore
Azure Training in Hyderabad
Azure Training in Pune
Azure Training | microsoft azure certification | Azure Online Training Course
Azure Online Training
Excellent Blog! I would Thanks for sharing this wonderful content.its very useful to us.This is incredible,I feel really happy to have seen your webpage.I gained many unknown information, the way you have clearly explained is really fantastic.keep posting such useful information.
ReplyDeleteFull Stack Training in Chennai | Certification | Online Training Course
Full Stack Training in Bangalore | Certification | Online Training Course
Full Stack Training in Hyderabad | Certification | Online Training Course
Full Stack Developer Training in Chennai | Mean Stack Developer Training in Chennai
Full Stack Training
Full Stack Online Training
Nice post. Thanks for sharing the valuable information. it’s really helpful. Who want to learn this blog most helpful. Keep sharing on updated posts…
ReplyDeleteAWS Course in Bangalore
AWS Course in Hyderabad
AWS Course in Coimbatore
AWS Course
AWS Certification Course
AWS Certification Training
AWS Online Training
AWS Training
Such a very useful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article.
ReplyDeleteIELTS Coaching in chennai
German Classes in Chennai
GRE Coaching Classes in Chennai
TOEFL Coaching in Chennai
spoken english classes in chennai | Communication training
Am Divya,Am really impressed about this blog because this blog is very easy to learn and understand clearly.This blog is very useful for the college students and researchers to take a good notes in good manner,I gained many unknown information.
ReplyDeleteData Science Training In Chennai
Data Science Online Training In Chennai
Data Science Training In Bangalore
Data Science Training In Hyderabad
Data Science Training In Coimbatore
Data Science Training
Data Science Online Training
Great survey, I'm sure you're getting a great response.
ReplyDeleteGreat post. keep sharing such a worthy information.
ReplyDeleteHadoop Training in Chennai
All our top-rated websites supply excellent bonuses for an excellent begin to your online slots expertise. The games themselves all supply excessive payout percentages to provide the greatest return on 카지노사이트 your bet, and cashing out any huge win could be very simple with all popular banking options. If you’re a winner, find a way to|you possibly can} expect any funds to be in your account within hours.
ReplyDeleteThanks for the post.it was very useful.
ReplyDeleteFull-stack course in Nagpur
thanks for this valuable information , keep posting and if you are intresting in web development then checkout my full stack classes in satara
ReplyDelete