Show Bid Request Merging arrays/Deleting items from an array Bid Request Id: 38899 Bookmark in my 'To Do' list Posted by: Sting-Ray (21 ratings) (Software buyer rating 10) Non-action Ratio: Very Good - 15.63% Posted: Dec 8, 2002 4:07:49 AM EDT Bidding Closes: Dec 22, 2002 4:36:15 AM EDT Viewed (by coders): 307 times Phase: 100% of work completed and accepted. Coder has been paid. Max Accepted Bid: Bidding is closed Project Type: Personal Project / Homework Help Bidding Type: Open Auction Categories: Visual Basic Enter chat room for this bid request (0 active users at Jun 30, 2003 10:59:03 PM EDT) Description: Feel free to ask for clarification because this is difficult to explain. I need the most efficient VB 6 function possible to merge one single dimension array to another, removing duplicates. I also need it to be able to remove items from an array by supplying another array with the same function. I also need it to sort the array in ascending order afterward. The example below is just 4 items for each array, but there may be over 1000 items in each array (input/output) to merge without duplicates, so it need to be fast and efficient. The "VariantToEdit" input will almost always be the variable I want to get back from the function. I envision the function looking something like this, but this may not be the best way: Private Function EditArray(VariantToEdit As Variant, Array As Variant, Add As Boolean) As Variant Except that I would like to supply a word to the Add input rather than a boolean. I'd like to have the function accept the word "Add" and "Remove". I don't know if this is possible. So when I'm typing the function in the IDE, for the last argument I want it to list Add or Remove, rather than True/False like a boolean. For example, the array to add to would be something like this: Jeff John Mary Kate Corbin Then the array (variant) I want to add in may be something like: Jim Jack John Jeff The output would then be: Jack Jeff Jim John Kate Corbin Mary Deliverables: 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased. Platform: Not platform specific, except for VB 6. Special Conditions / Other: Please complete within 2 days of acceptance. Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements. We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation. If you notice a violation please help out the site and report it. Thanks for your help.   Bidding/Comments: All monetary amounts on the site are in United States dollars. Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests. See all rejected bids (and all comments) Name   Bid Amount    Date   Coder Rating   This bid was accepted by the buyer! IP Enterprise (7 ratings) in Dublin, Ireland Ireland Bid id: 421,443   $20 (USD) Dec 8, 2002 8:07:59 AM EDT  10 (Excellent)     Hello, I just put this together for you as an example. The function behind the program takes two arrays and produces a string which can be split to form another array combining the original arrays minus duplicates, Let me know what you think, Regards Ross Attached File