I am working in a large team with multiple branches and merges happening on a regular basis. One thing that happens on regular basis is that web project files end up with duplicate entries for static content (.js, favicon.ico etc...). I have two methods to removing the duplicates: Delete the item in the Project Explorer (which remove...
How would you go about marking all of the lines in a buffer that are exact duplicates of other lines? By marking them, I mean highlighting them or adding a character or something. I want to retain the order of the lines in the buffer. Before: foo bar foo baz After: foo* bar foo* baz ...
I have an excel spreadsheet that has about 18k rows and three columns. I want to use this as a key in an Access database. So the three columns are [IDKeyNumber] [Name] [Category] The problem is in certain places the IDnumber is duplicated because the category has two category codes (typeA & typeB) All I really need to know how ...
Following code should throw exception to prevent adding duplicate collection item. ICollection<T> collection = new List<T>(); public void Add(T item) { if (collection.Contain(item)) { throw new SomeExceptoinType() } collection.Add(item); } What standard exception type is the most apropriate? ...
Hello all, I'm having problems with h2 headlines. sifr does replace the text, but as soon as it replaces the text inside h2 tags, after that it repeats the text in h2 but without sifr. Can anyone point me to the right direction what could cause this problem? Tnx in advance.. ...
Hello I have a table that has a lot of duplicates in the Name column. I'd like to only keep one row for each. The following lists the duplicates, but I don't know how to delete the duplicates and just keep one: SELECT name FROM members GROUP BY name HAVING COUNT(*) > 1; Thank you. ...
I have a table with some duplicate rows that I want to normalize into 2 tables. user | url | keyword -----|-----|-------- fred | foo | kw1 fred | bar | kw1 sam | blah| kw2 I'd like to start by normalizing this into two tables (user, and url_keyword). Is there a query I can run to normalize this, or do I need to loop through the tabl...
Hello, I am writing a simple application to copy a set of images to the user's photo library so that the user may use them as backgrounds. The problem is that if the user runs the application more than once, duplicate images will be copied to the photo library. Given the restrictions Apple places on accessing the contents of the photo l...
I have a table where I save all row-changes that have ever occurred. The problem is that in the beginning of the application there was a bug that made a bunch of copies of every row. The table looks something like this: copies |ID |CID |DATA | 1 | 1 | DA | 2 | 2 | DO | 2 | 3 | DO (copy of CID 2) | 1 | 4 | DA (copy of CID 1) | 2...
Hi I need SQL code that will identify possible duplicates in a table. Lets say my table has 4 columns: ID (primary key) Date1 Date2 GroupID (Date1, Date2, GroupID) form a unique key. This table gets populated with blocks of data at a time, and it often happens that a new block is loaded in that contains a number of records that are...
I have and ASP.NET 3.5 page where I need to debug some JavaScript code. function checkAll(isChecked) { debugger; var dataGridElements = document.getElementById('" + DataGridSearchResults.ClientID + @"').getElementsByTagName('input'); for (var i = 0; i < dataGridElements.length; i++) { var e = da...
Hello, I'm trying to come up with a method of finding duplicate addresses, based on a similarity score. Consider these duplicate addresses: addr_1 = '# 3 FAIRMONT LINK SOUTH' addr_2 = '3 FAIRMONT LINK S' addr_3 = '5703 - 48TH AVE' adrr_4 = '5703- 48 AVENUE' I'm planning on applying some string transformation to make long words abbrev...
I have a table like so: Table eventlog user | user_group | event_date | event_dur. ---- ---------- --------- ---------- xyz 1 2009-1-1 3.5 xyz 2 2009-1-1 4.5 abc 2 2009-1-2 5 abc 1 2009-1-2 5 Notice that in the above samp...
Tonight may be the night I crack... Okay, so if you would like a back story, look at my previous question I have finally decided that if this is possible, It's not worth the time it will take to figure out, since I really should have had this done before tonight anyway. So I decided to go another route: Figuring out which of my record...
I am trying to do a bulk upload into a SQL server DB. The source file has duplicates which I want to remove, so I was hoping that the operation would automatically upload the first one, then discard the rest. (I've set a unique key constraint). Problem is, the moment a duplicate upload is attempted the whole thing fails and gets rolled b...
I have a user that enters a piece of data into my database and titles it "Widget Title". If he calls another item "Widget Title", and another, and another, when he sees them in his widget list I'd like to show them like such: Some Item Widget Title Some Other Item Widget Title 2 Widget Title 3 Yet Another Item Widget Title 4 Where ea...
I have a table (participants) which has multiple columns that could all be distinct. Two columns that are of special interest in this query are the userID and the programID I have a two part inquery here. I want to be able to acquire the list of all userIDs that appear more than once in this table. How do I go about doing it? I want t...
I have an excel spreadsheet with two columns. The first column is a label the second column is a numeric value. I would like to remove all the duplicate labels in column "A" and remain with the maximun numeric value in column "B". I've tried to illustrate below (the filter would result in "Consolidated Sheet" given "Original Sheet": NOT...
I'm using mechanize and have a problem on one form... the form has two select boxes with the same name. How can I select the second one? ie. NumNights second occurrence. i found in the docs something like this: form.set_fields( :foo => ['bar', 1] ) but this didn't work: form.field_with(:name => [ 'NumNights', 2 ]).options[no_days...
I got the following code: int nnames; String names[]; System.out.print("How many names are you going to save: "); Scanner in = new Scanner(System.in); nnames = in.nextInt(); names = new String[nnames]; for (int i = 0; i < names.length; i++){ System.out.print("Type a name: "); names[i] = in.next(); } System.out.printl...