comparing two arrays

Posted on 2006-05-29
Medium Priority
Last Modified: 2013-12-18

I have array1 and array2.
Array1 has various datevalues
Array2 also has date values which are subset of array1
I want to create Array3 which has the remainder of Array1 or those documents which exists in Array1 and don't exist in Array2.

Is this possible?
Question by:varvoura
  • 2
  • 2
LVL 46

Accepted Solution

Sjef Bosman earned 500 total points
ID: 16783960
@TextToTime(@Trim(@Replace(@Text(Array1); @Text(Array2); "")))

Author Comment

ID: 16784003
I didn't think you'd still talk to me!
Actually, I have a specific question which I am going to post especially for you right now.
sjef, I hope you understand the spot that I am in at the moment. This thing will be completed by tomorrow, at least as a draft, but i have just ordered the book that you recommended.
Don't be too hard on me, trust me when I say, I am going to be on top of things as soon as this hurdle passes by.


LVL 46

Expert Comment

by:Sjef Bosman
ID: 16784176
Now why wouldn't I talk to you? Nobody's done anything wrong, as far as I can see. I can understand that there is a time to get things done and another time to do things right. That's your choice, we only tried to guide you into the right direction. If you want to be a full-time professional software developer, then act like one. Make requirements, analyse your system, design it and code it yourself! I might have been too zealous, overloading you with structure. Nevertheless, I strongly feel that you need it.

Furthermore, I think it's not fair to try to make me feel guilty over your job that's on the line. You make it seem you have no other option than to obey. I learned (the hard way) that you always have more choices than you think. But you'd have to be completely honest with yourself. End of comment, because it's sliding off towards psychology, and that had better not be handled here.


Author Comment

ID: 16784833
sjef, point taken.
A couple of things:

1. I am certainly going down the path of software development and I will succeed at it because for the next 12 months, this will be my food, drink and social life.

2. I don't have to always obey and actually at my last job, I became too comfortable to even listen to my boss. But this is a new position that I am in and fairly challenging, completely business oriented, so I have to perform according to their needs even though I have been there only for a few weeks.
The problem is I am loving the challenge so much, but I know that I don't have the complete knowledge for it and I am a bit stuck and working hard to learn what I can, yet still trying to perform according to their needs until I reach a comfortable point.
Can you understand now where I am coming from.
I do appreciate Marilyn's and your assistance and every line you guys wrote was taken into consideration, but again as I said, it seems hard to practice things when you have unfinished deliverable in 24 hours.

Anyway, enough of that, I may just post one more last question for tonight then go to bed, I have to wake up in 3 hours to go to work again.

I know that i have many other choices, but until I give what I am in now my best shot first!!

Have a lovely day sjef

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

IBM Notes offer Encryption feature using which the user can secure its NSF emails or entire database easily. In this section we will discuss about the process to Encrypt Incoming and Outgoing Mails in depth.
This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question