How to check if a vector contains n consecutive numbers

stackoverflow.com - 2013-04-20 07:52:15 - Similar - Report/Block

Suppose that my vector numbers contains c(1,2,3,5,7,8), and I wish to find if it contains 3 consecutive numbers, which in this case, are 1,2,3. numbers = c(1,2,3,5,7,8) difference = diff(numbers) //The difference output would be 1,1,2,2,1 To verify that there are 3 consecutive integers in my numbers vector, I've tried the following with l...

Date Difference between consecutive rows - complicated

stackoverflow.com - 2012-04-11 03:06:05 - Similar - Report/Block

I had previously posted a question which was answered but I need a query for this too. I have a table structure with data like this (dates in the format dd/mm/yyyy ID Account Number Unit Admit_Date Disch_Date 1 1001 w32 01/04/2012 2 1002 w32 01/04/2012 01/04/2012 3 1001 ccu 03/04/2012 4 1001 w33 05/04/2012 5 1003 cicu 04/04/2012 6 1001...

date difference between two dates

stackoverflow.com - 2012-02-27 06:40:39 - Similar - Report/Block

I want to calculate the date difference between form date and two date..Am using timespan to calculate the difference between two date if date difference is positive means it enter another process falls means it return error message. My partial code is here.. TimeSpan span = Convert.ToDateTime(txtenddate.Text).Subt ract(Convert.ToDateTim...

30K Rows: How Do I Identify Duplicate Rows (across 5 Columns) and Delete BOTH Rows?

excelforum.com - 2013-02-20 07:49:37 - Similar - Report/Block

Hi there, I've lost sleep over this and would appreciate your help. Here's what I'm dealing with (I've attached a screen shot and an .xlsx file for reference): I have a file containing 30,000 rows of data. There are 5 column headers: Name | Date | Employee # | Qty. | Meal Among the 30,000 rows, there are 5,200 rows that are duplicates. Wh...

Matlab: How to calculate the number of seconds between two date strings?

stackoverflow.com - 2013-06-07 18:34:43 - Similar - Report/Block

I have two dates in the following format: '16:40:07.875' '16:41:05.875' Now I try to use Matlab to calculate the difference between these two date strings in seconds. I thought the best approach is to first parse the date strings into a date type, but I couldn't find any date type in Matlab. Is there any? And is there a pre-built function...

[SOLVED] Date minus date in days

excelforum.com - 2013-04-21 16:33:31 - Similar - Report/Block

Dear Friends This is a great forum of sharp minds. I am working for a public Health program and need to know how I get the difference of two dates in days. e.g Cell A1 has date one and cell A2 has date 2 (both in mm/dd/yy format). I need the difference in days of these two dates in A3. Thanks in anticipation Dr Raj...

Showing Difference between two datetime values in hours

stackoverflow.com - 2011-02-09 15:39:44 - Similar - Report/Block

I am retrieving two date time values from the database. Once the value is retrieved, I need the difference between the two values. For that, I create a timespan variable to store the difference of the 2 date values. Timespan? variable = datevalue1 - datevalue2; Now i need to show the difference which is stored in the Timespan variable in...

Difference between Date.toJSON() and Date.toISOstring()

stackoverflow.com - 2013-04-24 17:29:48 - Similar - Report/Block

I was checking how to display JavaScript date in the following format: YYYY-MM-DDTHH:mm:ss.sssZ , but I saw two methods doing this: .toJSON() and .toISOstring() Is there some real difference between them?...

Can anyone help with adding dates to backups created in BAT files?

hardforum.com - 2013-03-15 10:43:53 - Similar - Report/Block

I'm having problems getting the date to appear correctly in my batch files. I am creating a rar backup of a folder and I want the date to appear in the filename. I have tried using the %date% variable as well as more advanced versions of "date" such as: MYDATE=%DATE:~0,2%%DATE:~3,2%%DATE:~8,4% MYDATE=%date:~0,4%%date:~5,2%%date:~8,2% MYDA...

Use LINQ to find duplicated rows (with list of specified columns)

stackoverflow.com - 2013-03-01 15:26:12 - Similar - Report/Block

I use the code below to get the duplicated rows for 3 columns: String, Date, Money. I wonder if there is any general method that I can input a dynamic List of column name in this LINQ to find duplicated rows? DataTable allDuplicates = dt.AsEnumerable() .GroupBy(dr => new Field1 = dr.Field("String"), Field2 = dr.Field("Date"), Field3 =...

SQL how to convert row with date range to many rows with each date

stackoverflow.com - 2013-05-03 12:29:17 - Similar - Report/Block

If I have a table that looks like this begin date end date data 2013-01-01 2013-01-04 7 2013-01-05 2013-01-06 9 How can I make it be returned like this... date data 2013-01-01 7 2013-01-02 7 2013-01-03 7 2013-01-04 7 2013-01-05 9 2013-01-06 9 One thing I was thinking of doing is to have another table that just has all the dates a...

Managers: Get Things Done More Efficiently

careerealism.com - 2013-02-25 09:00:19 - Similar - Report/Block

Leaders, managers … how often have you asked a team member to do something and found that it didn’t get done when you expected? Try this today… Tag ALL of your requests with a due date and time, particularly those that are time senstive and impact a due date or deadline that you have ownership date. Ask them: When can it be done – date an...

evolveStar Join

subtract values of two rows and inserting it into a new column (not subsequent rows)

stackoverflow.com - 2013-04-09 07:17:37 - Similar - Report/Block

relevant to my previous question here: how to insert subtract of each two subsequent rows and inserting it into a new column I have another question. In the following table; I want to calculate the amount of time that have passed from each user's last winning in a competition. in fact I should subtract the last winning date from current d...

Filter out aggregated rows SSRS

stackoverflow.com - 2013-03-06 12:23:55 - Similar - Report/Block

I have a fairly complicated report that I'm trying to edit. Below is a screenshot of the report: I need to filter out all rows where "Number not in Groups" is n/a or 0, I've tried filtering out using the filter option in tablix properties, but it wont let me due to the error: aggregate functions cannot be used in dataset filters. Below is...

Get all rows not filtered from jqGrid

stackoverflow.com - 2012-03-19 18:43:03 - Similar - Report/Block

I have local data in a grid. How can I get all of the rows or IDs that are not removed after a user uses the filter toolbar? I need to get all filtered rows, regardless of pagination. For example, say I begin with 50 rows in the grid. The user uses the filter toolbar and the set of rows decreases to 10 rows. How can I get those ten rows?...

how to limit the rows of datagrid in flex3?

stackoverflow.com - 2011-07-26 12:00:57 - Similar - Report/Block

I have a data grid consisting of 3 columns & many rows, i want to show only the first 20 rows to user. Is there any way i can show only the first 20 rows in my datagrid.After by clicking button 'next', next 20 rows should display and so on...

replace two consecutive spaces with one space in c [closed]

stackoverflow.com - 2012-03-22 09:40:31 - Similar - Report/Block

Possible Duplicate: How do I replace multiple spaces with a single space in C? I have a string in c that can contain two consecutive spaces. I want to remove two consecutive spaces with one space. How can I do that? Help please.

vb.net Source bounded Datagridview and ComboBoxColumn

stackoverflow.com - 2013-03-25 13:49:20 - Similar - Report/Block

My Questeion: Is it possible to add a DataGridviewComboBoxColumn to a DataGridView which is Source bound to DatTable? Explanation: I have a DataGridview wich is bound to a DataTable: Public Class frmZeiterfassung Private dt As DataTable Private Sub frmZeiterfassung_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load...

Google Spreadsheet script to Return table of subtotals

stackoverflow.com - 2013-05-05 02:01:07 - Similar - Report/Block

Here is my function to import a range (6 columns ; and lots of rows) from active spreadsheet and return subtotal grouped by the 5th column. var sheet = SpreadsheetApp.getActiveSheet(); var rows = sheet.getRange("A3:F"); var values = rows.getValues(); var expense = new Array(); var expensehead = new Array(); for (var i = 0, e = 0; i <= row...

How to get data from a cell in DataGrid

stackoverflow.com - 2012-04-28 16:58:15 - Similar - Report/Block

Hello I have a Data Grid That have columns that have check box. I would like to disable the check box on a certain condition. I have a SQL DB that I get from it a DataSet then I fill the data set inside the Data Grid. Here is some of my code Dim loopRow As Integer = ds.Tables(0).Rows.Count - 1 Dim ColDS As New DataColumn("Status") ds.T...

DELETE all date that is 1 hour older than the entered date. PHP

stackoverflow.com - 2013-05-13 18:34:37 - Similar - Report/Block

So I have this data in 'Login_attempts' table: id - username - attempts - expires - ip 4 jony 11 2013-05-13 And I want to delete ALL ROWS that are 1 hour old. I only know how to delete them by date, but not date and time. How would I do this? public function delete() $this->delete = $this->pdo->prepare("DELETE FROM login_attem...

Strange Access behaviour regarding subqueries

stackoverflow.com - 2012-04-26 14:27:23 - Similar - Report/Block

I have this code in Access: SELECT DISTINCT p.course, p.date FROM Student s, Participation p WHERE s.id = d.student AND footballer = NO When I run it, I get 10 rows. So I use it as a subquery the next time: SELECT c.course, c.date FROM Course c WHERE NOT EXISTS (SELECT DISTINCT p.course, p.date FROM Student s, Participation p WHERE s.id =...

When I select from sqlite database, java cursor is taking colums of particular row but I want rows

stackoverflow.com - 2013-04-17 11:20:58 - Similar - Report/Block

Sqlite Database with Java... My database is full of data and I want to select them between a date range. Query is selecting correctly but cursor is taking columns of a just 1 row. I have different rows. For example I want to get row Id's of rows in which dates are between parameters. But it only gets columns of one row. How can I select a...

QTextEdit inserting and removing rows is very slow. Anyway to make it faster?

stackoverflow.com - 2012-03-30 23:26:11 - Similar - Report/Block

I have a table with 50 rows in a QTextEdit object. Removing 50 rows 1 by 1, then adding 50 rows 1 by 1 takes around 1-2 seconds. Is there any way to speed up this operation. I only need to see the final result. (ie after i have finished removing then adding rows). Since i down know exactly what takes time i can not find a work around. Her...

Count number of in table using jquery

stackoverflow.com - 2013-02-26 17:44:12 - Similar - Report/Block

I just want to count the number of rows, Add row Number of rows: Javascript: $(function() { $('#add').bind('click', function() { $('#mytbody').after(''+ new Date() +''); var count = $('#mytbody').children().length; $('#counter').html(count); }); }); I found this jQuery - count number of rows in a table and this doesn't works http://...

mysql insert information from multiple rows from another table

stackoverflow.com - 2013-06-06 14:31:22 - Similar - Report/Block

I am using MySQL version 5.6 I have a table event that takes two ids and a date, and a table student that contains a column . I want to insert two ids when the name match (WHERE firstname =.., AND lastname=..,) . However, I don't quite know how to take from two rows in one insert command. Can any one help me please? Thanks, Paul...

Excel - Delete all one-to-one rows between two columns

stackoverflow.com - 2012-06-19 22:11:36 - Similar - Report/Block

Problem: I have Column A and Column B. Column A is predictable, there are thousands of column A rows. Column B has variying rows per Column A. For example, Column A may have the value REQ_000021 with 5 rows in Column B. Those are okay. The rows I need deleted are the ones where there is only one Column B per Column A. I know this isn't a...

update single column with multiple values on multiple rows

dbforums.com - 2012-07-30 16:32:55 - Similar - Report/Block

Hello! I need some assistance in writing an update sql query. I am having hard time finding this on google or the search feature on this forum. Here is what I would like to update. I have a table (TABLE_1) with 100 rows. I want to update a single column (STATUS_MSG) on 80% of rows with value 'A' 10% of rows with value 'B' 10% of rows with...

Symfony2 custom(hml5) date field creation

stackoverflow.com - 2012-03-26 01:04:38 - Similar - Report/Block

My target is to create a custom Date field (which should work with Doctrine). The main difference with the basic symfony's one is that it shouldn't be 3 dropdown's, but one <input type="date"> I've tried several tutorials like Symfony's book and some helpful answers here. However the more solutions I try to embed, the more problems...

Add rows to CSV File in powershell

stackoverflow.com - 2012-03-21 22:35:09 - Similar - Report/Block

Trying to figure out how to add a row to a csv file with titles. I get the content using: $fileContent = Import-csv $file -header "Date", "Description" $File Returns Date,Description Text1,text2 text3,text4 How do I append a row with a new date and description. Sorry I am relatively new to powershell. thanks to anyone that can help...

R: remove multiple rows based on missing values in fewer rows

stackoverflow.com - 2012-03-28 13:47:00 - Similar - Report/Block

I have an R data frame with data from multiple subjects, each tested several times. To perform statistics on the set, there is a factor for subject ("id") and a row for each observation (given by factor "session"). I.e. print(allData) id session measure 1 1 7.6 2 1 4.5 3 1 5.5 1 2...

Removing mulitple selected Rows + with rowspan

stackoverflow.com - 2013-03-18 21:10:36 - Similar - Report/Block

I would like to delete selected rows with rowspan and an extra one below, a total of 4 rows, you can see that each 4 stack of rows represent 1 entry. The function deleteSelectedRows() below does not work correctly; it only deletes the one selected. Could you please help! No Location Time 1a 1a 2a 2a 3a 3a 4a 1b 1b 2b 2b 3b...

[SOLVED] Can't Unhide rows?

excelforum.com - 2013-06-10 06:38:03 - Similar - Report/Block

I am trying to unhide rows but the Unhide command is not allowing me to? I have selected the entire worksheet and highlighted the rows. Is there another way of unhiding rows? Thanks in advance...

Delete rows that have duplicate data in certain columns

excelforum.com - 2013-04-20 01:42:02 - Similar - Report/Block

Hey everyone, I am currently working in excel2007 with a pretty big file of over 13,000 rows and 27 columns. A lot of these rows need to be deleted, because, for the most part, they are duplicates. I am looking to incorporate a macro that will look at 4 or 5 columns in each row and, if ALL of these columns are identical for a group of row...

How to convert string to dateTimePicker fromate in C#?

stackoverflow.com - 2012-02-29 07:03:06 - Similar - Report/Block

I am fetching data from database in datetable's object called dt. I want to convert that string in to dateTimePicker 's format . I have try below code but its not working . dtpPlanDate.Value = DateTime.ParseExact(dt.Rows[0]["PlanSDat e"].ToString(), "yyyy-MM-dd HH:mm:ss,fff", System.Globalization.CultureInfo.Invaria ntCulture); it gives me...

Database query issue

stackoverflow.com - 2012-03-12 19:47:09 - Similar - Report/Block

Relatively new to using database and for some reason I can't get this 'execute' to work. statment2.execute("insert into table Value (" + int + "," + date + "," + int + ",'" + string + "')"); The error I get is "missing a comma". The date is designated as dates only in that particular field. I set it up as follows Date date = new Date(); d...

How do compare dates when one of those are in string format in android

stackoverflow.com - 2012-04-15 13:20:10 - Similar - Report/Block

I am very much new to android so need some good help with a code example. I am getting a date in form of string from a server in the following format 2012-08-17 00:00:00 I want to compare this string with current date to find the difference between the dates in the form of year, months and days... I tried playing around it in the followin...

How to display 3 months in WPF datecontrol?

stackoverflow.com - 2013-03-20 19:08:24 - Similar - Report/Block

Is there a way to customize WPF date control to display 3 consecutive months on click ? Thanks in advance...

Get Date difference between a date and datetime fields using "Floor"

stackoverflow.com - 2012-04-24 09:08:50 - Similar - Report/Block

I am trying to get number of day differences using Floor function between a date and a datetime field. But i am getting one extra day. This is how I`m doing-> SELECT col,col1,FLOOR(col-col1) FROM tab_name Here col is just Date field,Col1 is DateTime Field Any idea?...

Select value from filter

stackoverflow.com - 2013-04-24 13:38:23 - Similar - Report/Block

I need a select statement which always returns at least one record. Something like this SELECT id, date FROM mytable WHERE id = AND date = UNION SELECT AS id, AS date FROM DUAL So should the query return 0 rows, it returns at least one row with the input values. Is this possible in SQL? I'm using Oracle 10.2 Btw. the query is just plain-t...


Fill out the form you see below. Registration is free, fast and simple.
If you are already registered, sign in page login.

Web Site :
Required Field
First Name :
Required Field
Last Name :
Required Field
Email :
Required Field
Sex :
Required Field

evolveStar.com is free for ever !

evolveStar.com provides a search engine that allows you to gather information to write their own blog.

evolveStar.com enhances the sources displaying the logo of the site.

If you want to remove your site or you believe a site listed infringes copyright, please report it to: info@evolvestar.com

Specifies the subject copyright violation and the url of the page

evolveStar.com respecting the law DMCA (Digital Millennium Copyright Act) will immediately remove whatever its merits.

Next will be effectual and relevant checks.

Who We Are Partner Advertising Contacts Privacy terms Help & FAQ

© Copyright 2010-2017 Fabrizio Fichera. All rights reserved.